select distinct p.phraseid,p.phrasename, case when p.phraseid in(select phraseid from samples) then 'True' else 'False' end as status from phrase p left join samples s on s.phraseid=p.phraseid
select distinct p.phraseid,p.phrasename, case when p.phraseid in(select phraseid from samples where sampleid = @sampleid) then 'True' else 'False' end as status from phrase p left join samples s on s.phraseid=p.phraseid
not quite what OP looks for
the above small tweak is needed to get required output
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
need of query
Posted - 11/15/2012 : 01:02:28
