a guest May 16th, 2018 109 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- Select Client.ClientID, dtmServiceEnd, clientname, State, ClientStateID from ClientState
- Inner Join Client on ClientState.ClientID = Client.ClientID
- INNER JOIN States ON ClientState.StateID = States.StateID
- WHERE ClientState.dtmServiceEnd < '" & date1 & "'
- And ClientState.dtmServiceEnd >= '" & date2 & "'
- And ClientState.AgentID is not null
- And ClientState.iStatus != 'Pending' AND Client.ClientStatus != 'Archive'
- Order By dtmServiceEnd
RAW Paste Data