Let say I have to tables:
the integer in tbl_homes.community would correspond to tbl_communities.id.
So how would I draw a query that would pull a distinct list of names BUT ONLY if there is a record in the tbl_homes table.
I tried this:
SELECT DISTINCT name FROM tbl_communities
But that pulled names from the table even though there weren't corresponding records in the homes table.
Can someone please help!!
( SELECT 1
WHERE community = tbl_communities.id )