[SQL statement for query]

To find the records that are in TableMaster but not in TableEncoding use a LEFT JOIN :-

 

SELECT m.ProvinceCode, m.CityOrMuni, m.BarangayName

FROM TableMaster m LEFT JOIN TableEncoding e

ON m.ProvinceCode = e.ProvinceCode  

AND m.CityOrMuni = e.CityOrMuni  

AND m.BarangayName = e.BarangayName  

WHERE e.ProvinceCode IS NULL

 

hth

 

sorry for being naive but, what does the \'m\' and \'e\' represents??

[SQL statement for query]

Good day to all. im using Access2000.

how can i make a query to find the missing records to my second table. tblMaster, tblEncoding has both no ID but they has same fields[ProvinceCode, CityOrMuni, and BarangayName]. any body has idea how can i solve this problem? by the way i have over 100thou records, so its kind a bloddy if i check this manualy..

 

just really need help. pls..