Table A -- Has mix of 3 & 6 digit zip codes
Table B -- has all 6 digit
I need to do inner join between A & B where first all 6 digit are matched once match are found you filter them from second inner join where match will be performed on first 3 digit code. final results will be combination of both matches.
It is not complicated:
Hope it helped u. Plz mark the answer as correct if it covered ur requirements