Re: SELECTS

[Christian Hamel]

Hmmm, it's not clear what you want to do.

Theses tables have a corresponding field? I mean, like an SalesOrders table can be joined to a Customers table using the CustomerID. If your tables have such a key you can do:

Select data1, data2
From table1
inner join table2 using (CorrespondingKey);