-
Query Problem [RESOLVED]
Hi, I am trying to execute th query below but keep getting the error below on MSSQL 2000. any ideas where i could be going wrong.
Code:
Select pb.name as name,
pb.cellnumber as cellnumber, pb.recordindex as pbindex,
pb.emailaddress as emailaddress,
gm.recordindex as groupindex,
gm.groupindex as gi
if gm.allowedbroadcast = 1,'Yes','No' as priv
if(gm.groupindex,'Member','Not Member') as ismember,
if(gm.allowedbroadcast = 1,'Privileged' ,'Normal') as Broadcast
FROM
groupmembers as gm LEFT
JOIN
phonebook as pb on (pb.recordindex = gm.phonebookindex)
WHERE
groupindex=34 order by gm.allowedbroadcast desc,
pb.name asc, pb.cellnumber asc
I get the error below
Line 6: Incorrect syntax near ','.
Line 7: Incorrect syntax near ','.
Line 8: Incorrect syntax near ','.
(0.300 sec)
Any help will be greatly appreciated.
-
Re: Query Problem
hi
try this is work or not
Code:
Select pb.name as name,
pb.cellnumber as cellnumber, pb.recordindex as pbindex,
pb.emailaddress as emailaddress,
gm.recordindex as groupindex,
gm.groupindex as gi,
if gm.allowedbroadcast = 1,'Yes','No') as priv,
if(gm.groupindex,'Member','Not Member') as ismember,
if(gm.allowedbroadcast = 1,'Privileged' ,'Normal') as Broadcast
FROM
groupmembers as gm LEFT
JOIN
phonebook as pb on (pb.recordindex = gm.phonebookindex)
WHERE
groupindex=34 order by gm.allowedbroadcast desc,
pb.name asc, pb.cellnumber asc
-
Re: Query Problem
Still not working. Is this the way to implement IF conditions in MSSQL?
-
Re: Query Problem
No, I'm afraid it doesn't support If within queries... you need to use Case instead.
An explanation and example can be seen in Books Online, the web based version is here.