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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access join not supported "sometimes".
First, thanks to lameid for the pass-through query suggestion. Changing the query to a PT allowed it to work with the failing join. I did attempt fixing it earlier with vba references but that didn't work, but thanks also for that suggestion. Now I have another problem created by the PT query...- Cicero01
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Access join not supported "sometimes".
I have an Access database in which I have a series of SQL server tables linked into Access with an ODBC connection. This is the SQL code in question: SELECT [dbo_Account].[acct_id], [dbo_Agent].[AgentName] FROM dbo_Account LEFT JOIN dbo_Agent ON...- Cicero01
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
