SQL statement for query

[vickriz]

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

[Barand]

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

[vickriz]

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

[shivabharat]

Its called an alias name

 

say you have a tabled name phpfreak you can create an alias named \"p\" and refer it by that name in the query.

 

select * from phpfream p where p.name=\"php\"

 

Alias names are typically used in joins!