Hi,
Thought to just comment on the "don't know how you'd join all three =
tables within a single SQL".
Joining 3 tables in a single SQL proves to be powerful, time saving and =
does not clutter your disk with unecessary temporary files. The way to =
do this requires a syntax rule which I will explain.=20
When joining TWO tables in a single SQL you define the realtionship =
between the two tables in the where clause box eg.=20
pointtable1.obj within regiontable.obj
When joining THREE tables in a single SQL you define the realtionship =
between the first two tables AND another relationship between the second =
and third tables eg. pointtable.obj within regiontable.obj and =
regiontable.obj contains pointtable2.obj.=20
It is good practice to add the tables in their correct relationship =
order.
Regards,
Laurence Seeff
Points Business Mapping Ltd.
22 Tuval St., Ramat Gan, 52522, Israel
=20
Tel: +972-3-6126216
Fax: +972-3-6126323
Email: [EMAIL PROTECTED]
Web: www.points.co.il
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
