SQL Query needed for fetch value from Two identical table but not fully identical table

SELECT *, NULL AS Field4
FROM TableA
WHERE Field1 NOT IN (SELECT Field1 FROM TableB)
UNION ALL
SELECT *
FROM TableB

Browse More Popular Posts

Leave a Comment