I need to join two tables in postgres (or any other SQL) like this:
table 1 has a list of phone numbers
table 2 has a list of country prefixes (like 40 for romania 407 for romania
mobile, etc)
I want to join the tables so that a number like
407111111 in table 1
is joined ONLY with
407 in table 2
Can you please help?
Thank you