Change the comparison between the data
MarikaA
Posts: 2
Good morning,
I have two tables: Person and Person1. These have only one column: "id". The data are respective: "Person@Mario", "Person@Sammy", etc into the first table, and "Person1@Mario", "Person1@Sammy", etc into the second table. Now I need to compare these tables, and I want that the result is equals, because I want that the substring "Person@" and "Person1@" are not included into the comparison.
There is a solution?
I have two tables: Person and Person1. These have only one column: "id". The data are respective: "Person@Mario", "Person@Sammy", etc into the first table, and "Person1@Mario", "Person1@Sammy", etc into the second table. Now I need to compare these tables, and I want that the result is equals, because I want that the substring "Person@" and "Person1@" are not included into the comparison.
There is a solution?