Finding two equal columns in two different table

Vote count:

0

I'm trying to find values in one table, where two columns are equal in another table, I tried creating a new column in these tables with both values ( "column 1" - "column 2" ) it does work but takes ALOT of time, is there a better way ?

tables are like this

TABLE ONE
NAME | ADDRESS | ZIPCODE | NUMBER | ZIPNUMBER | CITY

TABLE TWO
DATE | ZIPCODE | NUMBER | ZIPNUMBER

Then I use

Select * 
from t1 a 
inner join t2 b on a.zipnumber = b.zipnumber

asked 1 min ago

Edgar

1

Finding two equal columns in two different table