Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT bill_number, ( SELECT fit.trip_number FROM ( SELECT o.changed, it.trip_number FROM itriptlo it INNER JOIN odrstat o ON it.detail_line_id = o.order_id AND it.trip_number = o.trip_number AND o.status_code = 'ASSGN' WHERE it.detail_line_id = tlo.detail_line_id ORDER BY changed ASC FETCH FIRST 2 ROWS ONLY ) as FIT ORDER BY changed DESC FETCH FIRST ROW ONLY ) as FirstIntermediateTrip FROM tlorder tlo WHERE Date(pick_up_by) BETWEEN '2009-03-01' AND '2009-03-01' WITH UR
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to check if Database softwares installed on Windows Server||3||55|
|query error in former passthrough query||2||33|
|return value based on substr||10||53|
|MS Access TransferDatabase with ODBC - Receive Run-time error '2507'||1||26|