mesh 2 tables

[dan.h]

I need to mesh two (sometimes more)tables,of last names, and combining them into one recordset, displaying them in alphabeltical order.I think I have to use the SQL statement CROSS JOIN but I am unsure.
thanks
dan.h

[Iouri]

use UNION

sSQL = "SELECT CompanyName,City FROM Suppliers WHERE Country = 'Brazil' UNION" _
& " SELECT CompanyName, City FROM Customers WHERE Country = 'Brazil';"



Iouri Boutchkine
iouri@hotsheet.com

[dan.h]

Thanks
That was what I needed!
dan.h