You could use a left outer join, something like
select tblMinistries.Homecellname, case when tblNewMinistries.Homecellname isnull then 0 else 1 end as checked from tblMinistries left outer join tblNewMinistries on tblMinistries.Homecellname = tblNewMinistries.Homecellname order by tblMinistries.Homecellname
This way you would retrieve both the item and its checked state (as
0
or
1
).