SQL Query:
SELECT t1.stone FROM newatt t1 LEFT JOIN att t2 ON t2.stone = t1.stone WHERE t2.stone IS NULL
newatt = new table (contains updated extra rows)
att = old table
stone = column name on both tables
SQL Query:
SELECT t1.stone FROM newatt t1 LEFT JOIN att t2 ON t2.stone = t1.stone WHERE t2.stone IS NULL
newatt = new table (contains updated extra rows)
att = old table
stone = column name on both tables
Leave a Reply