how to query 2 tables for matching fields
Hi, basically I have 2 tables in a database, 'notBuilt' and 'built'. The column names are similar being 'model', 'location', 'price', and 'features' in each table. I have a query for the 'notBuilt' table,arrayed, and echo out and everything works fine. What I would like to do is add a second query to search if there is a built model available at a location. So if both the 'model' and 'location' match in both tables, I can add an if query match then available = yes, else no. I have tried a number of variations, but cant seem to get it correct.
Thanks