Array Comparison - (Moved)

[genius257]

So i think @iamtheky is right.

Every Solution Change Number seems to be unique.

I've checked in a SQLite database and made a quick look over of ID's + handpicked a few for manual match test.

Edit:

Copying a row from table A to table B and running the Query in reverse is evidence enough, i would say?

Query:

SELECT * FROM (SELECT * FROM A UNION SELECT * FROM B) WHERE SolutionChange IN (SELECT SolutionChange FROM A WHERE A.SolutionChange IN (SELECT SolutionChange FROM B) UNION SELECT SolutionChange FROM B WHERE B.SolutionChange IN (SELECT SolutionChange FROM A))

Note: I changed the type and DescriptionofIssue column values before adding it to table B

Edited July 13, 2018 by genius257

[Gianni]

hi @iamtheky , you are right, since there are not commonalities in the 2 arrays, all records are returned... If I include both rows 0, I get only one set of the header... no, I do not get any header.
@genius257, your SQL query is indeed ok

Edited July 13, 2018 by Chimp