Query Problem [RESOLVED]

[Paradox]

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.

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.

[mehul.pandya]

hi

try this is work or not

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

[Paradox]

Still not working. Is this the way to implement IF conditions in MSSQL?

[si_the_geek]

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.