Re: Another newbie question
I've worked it out. Thanks to everyone for your help
SELECT *,
CASE EXISTS ( SELECT * FROM QSL as b WHERE a.Country=b.Country and `QSL`="Y" )
WHEN TRUE THEN 'N'
ELSE 'Y'
end as NC,
CASE EXISTS ( SELECT * FROM QSL as b WHERE a.Country=b.Country and a.Mode=b.Mode and `QSL`="Y" )
WHEN TRUE THEN 'N'
ELSE 'Y'
end as NM,
CASE EXISTS ( SELECT * FROM QSL as b WHERE a.Country=b.Country and a.Band=b.Band and `QSL`="Y" )
WHEN TRUE THEN 'N'
ELSE 'Y'
end as NB
FROM QSL as a
Subject
Written By
Posted
February 06, 2014 11:58PM
February 07, 2014 01:11AM
February 07, 2014 06:41AM
February 07, 2014 11:15AM
February 07, 2014 07:50PM
February 08, 2014 11:54AM
February 08, 2014 05:41PM
February 08, 2014 06:55PM
February 08, 2014 06:59PM
Re: Another newbie question
February 08, 2014 08:48PM
February 09, 2014 02:56AM
February 09, 2014 07:43PM
February 10, 2014 02:31PM
February 11, 2014 05:10AM
February 11, 2014 10:41AM
February 11, 2014 08:12PM
February 12, 2014 12:50AM
February 12, 2014 08:32AM
February 12, 2014 07:39PM
February 12, 2014 10:47PM
February 12, 2014 11:50PM
February 13, 2014 12:00AM
February 13, 2014 02:14AM
February 13, 2014 11:10PM
February 16, 2014 12:51AM
February 27, 2014 04:54AM
February 27, 2014 08:47PM