Automatic Data Entry
Peter De Berdt
peter.de.berdt at pandora.be
Fri Oct 29 15:48:01 CDT 2004
> Simply Kim:
>
> s = "select RecID, story_name, heading, sub_heading, caption, body,
> story_writer, section, publication, depth, page, comment from stories
> where
>
>
> If you need join tables then
>
> SELECT ..
> FROM T1, T2
> WHERE T1.RecID = T2.ObjectPtr
>
You can even just say "SELECT ... FROM T1,T2" because the ObjectPtr
already knows how to join the two tables.
>
> You can use RecID by name.
>
And if you need the RecID in the SELECT query, you need to include it
in the query, even if you are using SELECT * (it's all in the docs if
you have not read them yet):
SELECT ..., RecID FROM T1
Best regards
Peter De Berdt
More information about the Valentina
mailing list