I am using the following sql:
SELECT [Sec Groups].[Group Name], [Sec Objects].Type,
[Sec Objects].[Object Name], [Sec Permissions].secAdd,
[Sec Permissions].secDel,
[Sec Permissions].secEdit, [Sec
Permissions].secOpen
FROM [Sec Groups] INNER JOIN
[Sec Permissions] ON [Sec Groups].
[Group No] = [Sec Permissions].[Group No] INNER JOIN
[Sec Objects] ON [Sec Permissions].
[System Name] = [Sec Objects].[System Name]
When I try to run the query in the query designer, I get
the following error message :
syntax error (missing operator) in query expression
I don't see an error in this sql statement. Vb.net
generated it anyway. When I generate the same sql in ms
access it runs fine...This happens everytime I try to run
a select statement that contains more than two tables.
Kevin