Table Data

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

192 records   7875 ms
tnsinfo_gps_id
025000300000868998036983944
008000600000000001802228354
008000600000000001802228334
001001200000010140200000045
022000100000000000020074685
002000000000000000000535701
043000100000359857080998693
001000800000011045100000016
001000800000011045100000014
002000400000000000000532304
00400060000000IJ3CIA8301199
0110003GPSASIA-181100008763
002000400000000000000523096
001000800000011045100000030
02800040000000GBNF621000096
001000800000011045100000003
008000600000000001902218058
001000800000010039200000010
043000100000359857081000333
001000100000010337200000004
20 of 192 Records