Jump to content

SQL statement for query


vickriz

Recommended Posts

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..

Link to comment
https://forums.phpfreaks.com/topic/844-sql-statement-for-query/
Share on other sites

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

Link to comment
https://forums.phpfreaks.com/topic/844-sql-statement-for-query/#findComment-2816
Share on other sites

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??

Link to comment
https://forums.phpfreaks.com/topic/844-sql-statement-for-query/#findComment-2829
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.