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
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