Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb_dotnet thread: vb.net sql syntax when joining more than two tables


Message #1 by kswiber@h... on Wed, 29 May 2002 20:58:45
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

  Return to Index