Click to See Complete Forum and Search --> : Inner Join


August 10th, 1999, 01:30 AM
When I try to Query from two tables which has a many to many relation from MSAcess, I get a SQL statement which has a Inner join. I don't fine any difference between the Inner Join and a where clause. Is this SQL query with inner join compatible with other Data Bases.

Lothar Haensler
August 10th, 1999, 02:36 AM
Access' INNER JOIN syntax is compatible with e.g. SQL Server 6.5 and above.