Features, features...

[Chris Aernoudt]

Guess I'm not....
Damn, I need more complex SQL....

Does this querying as described on page 41 of the VSQL ref only work on
fields of type objectPtr?
Is a query with this functionality possible in VSQL?

SELECT * FROM sometable INNER JOIN othertable ON othertable.ID =
CAST(substr(sometable.somefield, 2, 2) AS NUMERIC)

Or do I have to nest SELECT's?

Thanks,
Chris.

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chris
Aernoudt
Sent: donderdag 19 juni 2003 11:24
To: 'Valentina Developers'
Subject: RE: Features, features...

Scratch that, I need to learn how to read.... I'm stuck in the dark ages
:)

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chris
Aernoudt
Sent: donderdag 19 juni 2003 11:20
To: valentina at lists.macserve.net
Subject: Features, features...

How about implementing the sql JOIN & INNER JOIN commands? (yeah, I
know, there's the objPtr-link)

Would be very handy :)
I'm an SQL junk ;)


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina