sql help for MS SQL server 2000???

[zathrone]

I am having not getting idea to build a sql statement in sql server 2000, someone plzz give a glance to my attachment and help me solve it.

Thanks in advance.

[nosepicker]

Maybe there's an easier way, but you can try this:

SELECT MULT.feeName, CASE WHEN Fees.feeName IS NOT NULL THEN 'Yes' ELSE 'No' END AS [Added]
FROM

(SELECT feeID, feeName
FROM tblFee
WHERE feeType = 'Multiple') AS MULT

LEFT JOIN

(SELECT tblFee.feeID, tblFee.feeName
FROM tblFee
JOIN tblFeeDetail ON tblFee.feeID = tblFeeDetail.feeID
JOIN tblMember ON tblMember.mID = tblFeeDetail.memID
WHERE tblMember.mID = 1) AS Fees

ON MULT.feeID = Fees.feeID

[zathrone]

Thanks a lot man , it worked perfectly... more than that for newbie like me this kinda code is an inspiration to learn new things.. Thanks Dude..