Searching for an item that exists in Either Table A or Table B

[jmastromauro]

Server version: 4.1.22-standard + PHP 4.7

 

I am trying to find something that is in either on table or the other with one querey:

 

SELECT country.counName, location.locaName, location.locaShortName

FROM country,location

WHERE country.counAbbreviation='$sub_text' OR location.locaAbbreviation='$sub_text'";

 

The $sub_text is an abbreviation that will occur in only one of the tables.

 

First time I have tried this... I am not sure how to do it.....  It would seem to me that it could be done in one query.

 

[atticus]

are you getting an error?