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
Printable View
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
use UNION
sSQL = "SELECT CompanyName,City FROM Suppliers WHERE Country = 'Brazil' UNION" _
& " SELECT CompanyName, City FROM Customers WHERE Country = 'Brazil';"
Iouri Boutchkine
[email protected]
Thanks
That was what I needed!
dan.h