Hi John,
I haven't excactly tried it myself, but this ought to do the the job:
1. This SQL query requires that both of your tables has a Integer column.
Lets call it OUTJOIN
All the values in these two column should be the same, for instance 1.
2. Your SQL syntax would then be (I guess you
How do users get around doing a full join on two tables in MI Professional's
SQLSelect?
Example: I want selection to include a full join on table1.ID1 and
table2.ID2, even if ID1 and ID2 do not match?
The way SQLSelect works it must be an inner, left, or right join, but no
full join.
TIA
-John