I like to have the following query:
I have two tables (datatype text):
objectid1 with content like CHB01010, CHB01506, CHB01517
objectid2 with content like CHB01010/F, CHB01506/DYYYO, CHB01517/ZYYYO
I like to compare both tables so where object_id1 = object_id2
Can you build this query for me?
I'm looking for a postgresql specialist, who can help us also with later work.