query problem (1 Viewer)

[parara]

Hi to anybody ,
here is my problem.
I have 3 tables ,
t1 with fields (t1ID , orderID , custID , date , amount , logID)
t2 with fields (t2ID , orderID , mesiID , date , amount , logID)
t3 with fields (t3ID , orderID , driveID , date , amount , logID)

I am trying to create a query with following info

from t1 custID , date , amount , logID
from t2 mesiID , date , amount , logID
from t3 driveID , date , amount , logID

I want to have only a query with above info by row , for example



date , custID , amount , logID , orderID
date , mesiID , amount , logID , orderID
date , driveID , amount , logID , orderID
....
....
...
...
date , custID , amount , logID


the fields , date , amount , logID maby are the same on some records

 

[jdraw]

Why do the three tables all have the same structure?
Why nit just 1 table?

Look up UNION query.

 

[parara]

OK. I have 3 tables because ,
i have 1 order. For this order i must pay my supplier , the driver , and the person who make the sale.

So , i am using 1 table for supplier payment , 1 table for drivers and 1 for sales-man. When i pay , i use different bank-account . Each bank-account can be pay a supplier , or driver or sale-man ... or both of them. I want to control these bank-accounts so i thought to create a query from three tables and then filtering it with bank-account ID.

 

[jdraw]

You should review this article

http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

and learn Normalization to get your tables structured.
It will make your database activities less convoluted and more efficient and useful.