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)
>
> CR
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-