database - Get me a SQL quesry to check whether the two table data contents are equal? -

i having 2 table , b of same structure.both tables loaded data.i want mismatched row of 2 tables.,,

i'm gigantic join query each column , issue not in on result simple, pragmatic solution to:

1. write query orders data on several columns (or all)
2. export query executed on each table separate text file
3. use diff compare files each other

depending on rdbms vendor may have other options consider well.