In Search of the correct SQL statement

SELECTCompanyName FROM Adjusters
UNION
SELECTCompanyName FROM Insurance
UNION
SELECT CompanyName FROM Brokers
ORDER BY CompanyName


If the field names for companies are different in the three databases, use "ORDER BY 1" (the position, rather thanthe inconsistentvariable name)... like this



SELECTCompany FROM Adjusters
UNION
SELECTCompanyName FROM Insurance
UNION
SELECTBrokerage FROM Brokers
ORDER BY 1


Hope this helps.


Mike Reilly, Secretary/Webmaster
Kiwanis Club of Rancho Penasquitos
"Serving the Children of the World"
[email protected]
www.KiwanisPQ.org
(760) 419-7429

 

I have 3 tables with company names

t1.adjusters
t2.insurance
t3.brokers

I want to return a dataset (single column) with unique company names fromall 3 tables (sorted)


HELP!!

 

It Sure did !!

Thanks