I need help to find whether the record is there in both the table or just one table
SELECT a.producttype, b.amount, Status From Table1 a Left outer join Table2 b on a.numberid = b.numberid
the column Status = both, when there is matching record in both the table
Status = table1 when there is record only in table1
Status = table2 when there is record only in table2
Any suggestion will be of great help
thanks in advance.