Subject | Joins & TIB_Query |
---|---|
Author | Steven Beames |
Post date | 2000-11-26T20:03:30Z |
Hi all,
Using TIB_Query's editor to add multiple tables to the SQL (and filling in
the JoinLinks) seems to produce a JOIN...WHERE statement (which bombs out),
rather than a JOIN....ON statement. Can you produce a proper JOIN using the
editor, or do I have to manually assign the correct SQL?
IBO 3.6Be, BCB5/Update1, IB5.6
Cheers,
Steve
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Using TIB_Query's editor to add multiple tables to the SQL (and filling in
the JoinLinks) seems to produce a JOIN...WHERE statement (which bombs out),
rather than a JOIN....ON statement. Can you produce a proper JOIN using the
editor, or do I have to manually assign the correct SQL?
IBO 3.6Be, BCB5/Update1, IB5.6
Cheers,
Steve
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com