J John Spencer (MVP) Nov 15, 2003 #2 No there is not. You need to do two Outer JOINs (LEFT JOIN OR RIGHT JOIN) and THEN use a UNION query to combine the results.
No there is not. You need to do two Outer JOINs (LEFT JOIN OR RIGHT JOIN) and THEN use a UNION query to combine the results.
V Van T. Dinh Nov 15, 2003 #3 Full Outer Joins are not available in JET SQL. You need to UNION the LEFT OUTER JOIN and the RIGHT OUTER JOIN to simulate a full outer Join.
Full Outer Joins are not available in JET SQL. You need to UNION the LEFT OUTER JOIN and the RIGHT OUTER JOIN to simulate a full outer Join.
P Peter Surcouf Nov 25, 2003 #4 I use access front end to a sql7 back end which means I can do a pass through, would it not be possible to put the data in an MSDE backend and then use pass through? peter
I use access front end to a sql7 back end which means I can do a pass through, would it not be possible to put the data in an MSDE backend and then use pass through? peter