I need help with a sql query to select all columns where 2 state codes(PQ and QC) share the same city code. I dont know the value of CityCode.
All of these columns are in a table called tbCompanyCityMaster.
psuedo code below.
select * from
where state in('QC','PQ') and CityCode (is same citycode for both 'QC' and 'PQ')