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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can Access generate a.ID=b.ID (not INNER JOIN) in SQL?
The other thing - most of the people I work with use hand-coded SQL, not Access. Though some use MS Query, which seems to do a.ID = b.ID joins.- whit0313
- Post #11
- Forum: Microsoft: Access Queries and JET SQL
-
Can Access generate a.ID=b.ID (not INNER JOIN) in SQL?
does anyone know how to tweak the way Access generates SQL By writing yourself the FROM and WHERE clause ... Fair 'nuff. I figured that was probably the only way - thanks anyway though. Just a question if I may ask: how the people you work with write outer joins ? Generally it's something...- whit0313
- Post #10
- Forum: Microsoft: Access Queries and JET SQL
-
Can Access generate a.ID=b.ID (not INNER JOIN) in SQL?
OK, I can see that INNER JOIN is the preferred method for pretty much everyone, and I take cheerio's point about the potential for 1,000,000 row tables. But, the people I work with all use a.ID=b.ID joins, and I'm expected to follow suit. So, with due acknowledgement that it's not a...- whit0313
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Can Access generate a.ID=b.ID (not INNER JOIN) in SQL?
I'm doing some queries in Access Design view, then using the generated SQL elsewhere. Unfortunately, when Access generates SQL, the joins are all INNER JOINs, not simply "where table1.id = table2.id". For example, I get this: SELECT Dept.DeptID, Dept.Name, Staff.Surname FROM Dept INNER JOIN...- whit0313
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
