I use MS SQL Server. I don't know what I'm doing wrong in the following query.
I receive this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.
select (table.isNegative, matchType.code, keyword.id, status.code, keyword.lastUpdate, syncStatus.code)
from table kwd, matchType, keyword k, status, syncStatus
I'm going to guess that "table" is a reserved word in your database. (Do you really have a table named "table"?)
Joined: Nov 01, 2011
Found the problem! Needed to remove the open and close () from the beginning and end of SELECT statement which got rid of the first error. Then I got "cannot be bound" error which I resolved when I replaced the actual table names with the names which was defined in from statement: kwd for table and k for keyword.