Table Data

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

194 records   2765.625 ms
tnsinfo_gps_id
008000600000000001802228354
008000600000000001802228334
001000800000011045100000014
008000600000000002002218007
0390002000000000000EE199173
001000100000010337200000004
010000006012820011-S1201405
008000600000000002002218054
001000800000011045100000018
001000500000000191510105124
008000600000000001802228339
104000200000017004710042705
025000600000359857082650599
013000400000868998035975008
0390002000000000000EE134057
047000100000359857080998693
001000800000011045100000022
14200010000000SW30019050288
008000200000000001603328076
0390002000000000000EE201790
20 of 194 Records