Table Data

ข้อมูล Select tnsinfo_gps_id from vehicle_transportinformation where tnsinfo_created_at>'2021-04-08 00:00:00' and tnsinfo_gps_id not in (select wtr_gps_id from vehicle_wastetruck) group by tnsinfo_gps_id

135 records   2484.375 ms
tnsinfo_gps_id
025000600000359857084198795
008000600000000001802228354
008000600000000001802228334
043000100000000000000010343
008000600000000002002218007
003000900000000011870501582
025000600000359857084197193
010000006012820011-S1201405
008000600000000002002218054
003000900000000011870501761
008000600000000001802228339
104000200000017004710042705
025000600000359857082650599
047000100000359857080998693
14200010000000SW30019050288
008000200000000001603328076
1200001000000000000T2004037
048000100000000000000063022
025000600000359857082644253
003000900000000012070200158
20 of 135 Records