Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nicklaspet
- Order by date
-
JOIN Conditions becoming Where Conditions
No, thats the old JOIN standard, have tried that, it doesnt work eighter, its an INNER JOIN, and it seems that Access doesnt accept the use of *= instead, that should make it a LEFT JOIN, support for the older standard SQL queries seem to be on its way out, thanks anyway Tim. SELECT DISTINCT...- nicklaspet
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
JOIN Conditions becoming Where Conditions
I have found that the folowing query gives the wrong result in number of hits, because its a LEFT JOIN it should return all rows from Table1 but does only return a subset, it seems that the Access engine makes the second condition in the Join condition a where condition instead of a condition...- nicklaspet
- Thread
- Replies: 14
- Forum: Microsoft: Access Queries and JET SQL
