|
The Omega
New Member
55 Posts |
 Posted - 17 September 2003 : 00:45:17
|
I need some help with the particulars on this sql statement.
Here is the current statement I have writen up.
"SELECT D.ad_DispatchID, D.ad_Pickuptime, D.ad_Readytime, D.ad_Calltime, D.ad_Dispatchtime, D.ad_From, D.ad_Fromaddy, D.ad_Fromaddy2, D.ad_To, D.ad_Toaddy, D.ad_Toaddy2, D.ad_HAWB, D.ad_Move, D.ad_Trip, D.ad_Pieces, D.ad_Weight, D.ad_Vehicle, D.ad_Who, D.ad_Customer, D.ad_Dispatcher, D.ad_Arrival, D.ad_PODtime, D.ad_PODto, D.ad_Notes, D.ad_Signature, D.ad_Rate, D.ad_DriverID, D.ad_Confby, D.ad_Charges, D.ad_DispatchDate, S.ds_Total, P.di_Full, P.di_Cell, P.di_Home FROM (Dispatches D LEFT JOIN Statuses S ON (D.ad_DriverID = S.ds_DriverID) ) LEFT JOIN Driver P ON D.ad_DriverID = P.di_DriverID"
Here is what I am trying to change too.
"SELECT D.ad_DispatchID, D.ad_Pickuptime, D.ad_Readytime, D.ad_Calltime, D.ad_Dispatchtime, D.ad_From, D.ad_Fromaddy, D.ad_Fromaddy2, D.ad_To, D.ad_Toaddy, D.ad_Toaddy2, D.ad_HAWB, D.ad_Move, D.ad_Trip, D.ad_Pieces, D.ad_Weight, D.ad_Vehicle, D.ad_Who, D.ad_Customer, D.ad_Dispatcher, D.ad_Arrival, D.ad_PODtime, D.ad_PODto, D.ad_Notes, D.ad_Signature, D.ad_Rate, D.ad_DriverID, D.ad_Confby, D.ad_Charges, D.ad_DispatchDate, S.ds_Total, P.di_Full, P.di_Cell, P.di_Home, C.ci_Fullname FROM (Dispatches D LEFT JOIN Statuses S ON (D.ad_DriverID = S.ds_DriverID) ) LEFT JOIN Driver P ON D.ad_DriverID = P.di_DriverID LEFT JOIN Customer C ON D.ad_Customer = C.ci_Customer"
Access needs a series of brackets that I dont know how to arrange. |
Edited by - The Omega on 17 September 2003 00:46:16 |
|
Topic Locked
