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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wave55
-
perform INNER JOIN on query results
I've tried your code and errors popped up. Through trial and error I've found in A97 the identifier to the left of INNER JOIN must be a table name and not a query. Even using an alias will not work. This was probably changed in later versions of Access. A kind soul on another forum pointed me...- wave55
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
perform INNER JOIN on query results
Im using Access 97 and the query is complaining about a "syntax error missing operator". I suspect it has something to do with using two SELECTs for the INNER JOIN. INNER JOIN expects table names but I thought a SELECT returns a table. SELECT * FROM Card WHERE Card.pk IN ( (SELECT DISTINCT...- wave55
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
