Hello,
I have an issue with 2 join tables.
I have 2 product tables with product codes and product names. Table A and Table B.
T B and T A have in common column ID product code, a numeric attribute. I want to find out which products from Table A can be found in Table B, and there where the joint fields are equal I want to add (in the resulted query) a column (lets name it Results)to mark the equal joint fields with the name Product1, and where the joint fields are not equal ( products from B which are not in A)to mark them in the same column Results with the name Product2 or null. In fact I want a table with all codes, and where codes from Table A can be found in Table B to be marked with a value and where are not to be marked with an other value.
Can this query be made in one stept or more? And which are the steps?