Incorrect syntax near the keyword FROM

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Incorrect syntax near the keyword FROM

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2007-04-13 : 11:21:49

Please i don't know what is wrong here: it works on my database but on the network in the production i get the following error:I am very confused.
*************************************
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'FROM'.
****************************************

SELECT DISTINCT D.ProgNO, E.ProjNO, F.ContractNO, A.CWONO,
A.KFID, A.SequenceNO, A.KFType, A.RFTitle, A.Deleted,
FROM
TAB_ccsNetKF AS A JOIN TAB_ccsNetUserAccess AS B ON (A.ProgID = B.ProgID AND A.ProjID = B.ProjID AND A.ContractID = B.ContractID) INNER JOIN TAB_ccsNetPrograms D ON A.ProgID = D.ProgID
INNER JOIN TAB_ccsNetProjects E ON A.ProjID = E.ProjID
INNER JOIN TAB_ccsNetContracts F ON A.ContractID = F.ContractID
WHERE B.UserName='JSmith' AND A.Deleted = 0 AND B.ccsNetModule = 'KF'

****************************************************

Thank you very much for the information....

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-13 : 11:23:21

Remove the extra comma , after A.Deleted before the FROM


SELECT DISTINCT D.ProgNO, E.ProjNO, F.ContractNO, A.CWONO,
A.KFID, A.SequenceNO, A.KFType, A.RFTitle, A.Deleted ,
FROM
TAB_ccsNetKF AS A JOIN TAB_ccsNetUserAccess AS B ON (A.ProgID = B.ProgID AND A.ProjID = B.ProjID AND A.ContractID = B.ContractID) INNER JOIN TAB_ccsNetPrograms D ON A.ProgID = D.ProgID
INNER JOIN TAB_ccsNetProjects E ON A.ProjID = E.ProjID
INNER JOIN TAB_ccsNetContracts F ON A.ContractID = F.ContractID
WHERE B.UserName='JSmith' AND A.Deleted = 0 AND B.ccsNetModule = 'KF'

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2007-04-13 : 11:24:09

Sorry i figured out i see the Comma in front of From keyword.

Thank you.....

quote:
Originally posted by cplusplus

Please i don't know what is wrong here: it works on my database but on the network in the production i get the following error:I am very confused.
*************************************
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'FROM'.
****************************************

SELECT DISTINCT D.ProgNO, E.ProjNO, F.ContractNO, A.CWONO,
A.KFID, A.SequenceNO, A.KFType, A.RFTitle, A.Deleted,
FROM
TAB_ccsNetKF AS A JOIN TAB_ccsNetUserAccess AS B ON (A.ProgID = B.ProgID AND A.ProjID = B.ProjID AND A.ContractID = B.ContractID) INNER JOIN TAB_ccsNetPrograms D ON A.ProgID = D.ProgID
INNER JOIN TAB_ccsNetProjects E ON A.ProjID = E.ProjID
INNER JOIN TAB_ccsNetContracts F ON A.ContractID = F.ContractID
WHERE B.UserName='JSmith' AND A.Deleted = 0 AND B.ccsNetModule = 'KF'

****************************************************

Thank you very much for the information....

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2007-04-13 : 11:25:04

Thank you KH.....i see that as soon as i posted it on the sqlteam

quote:

Originally posted by khtan

Remove the extra comma , after A.Deleted before the FROM


SELECT DISTINCT D.ProgNO, E.ProjNO, F.ContractNO, A.CWONO,
A.KFID, A.SequenceNO, A.KFType, A.RFTitle, A.Deleted ,
FROM
TAB_ccsNetKF AS A JOIN TAB_ccsNetUserAccess AS B ON (A.ProgID = B.ProgID AND A.ProjID = B.ProjID AND A.ContractID = B.ContractID) INNER JOIN TAB_ccsNetPrograms D ON A.ProgID = D.ProgID
INNER JOIN TAB_ccsNetProjects E ON A.ProjID = E.ProjID
INNER JOIN TAB_ccsNetContracts F ON A.ContractID = F.ContractID
WHERE B.UserName='JSmith' AND A.Deleted = 0 AND B.ccsNetModule = 'KF'

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-13 : 11:27:19

quote:
i see that as soon as i posted it on the sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources