Re: [PHP-DB] How to exclude the result of union of two tables from the result of union of other two tables

Oz wrote: I have a php page where I would like to list a numer of companies as below: 1- retrieve all distinct company names from TableA (SELECT company_name FROM TableA) CREATE TEMPORARY TABLE temp1 SELECT DISTINCT(company_name) FROM TableA 2- retrieve all distinct company names from TableB 3-

Re: [PHP-DB] How to exclude the result of union of two tables from the result of union of other two tables

This can be done in one query using subselects. El Vie 05 Sep 2003 15:49, John W. Holmes escribi: Oz wrote: I have a php page where I would like to list a numer of companies as below: 1- retrieve all distinct company names from TableA (SELECT company_name FROM TableA) CREATE