HELP! Comparing 2 linked tables

I am trying to compare 2 linked tables (to comma delimited files) one comes from our production environment, and the other from the QA environment. Each file has the same amount of columns, in the SAME order. I need to compare the fields between both files to determine if they match. There is no primary key per se, but I have set up a union of the two files.

Any thoughts/suggestions?

Thanks.

craig

I don't know i can help or not, I can't really picture what you said.

U want to compare the 2 tables and one more table from another database issit?

Select <Column1>, ... From <Table1> (Inner Join | Left Join) <Database1>.dbo.<Table2> on <Column1> = <Database1>.dbo.<Table2>.<Column1>
Order by ...
Group by ...

Does this help? Sorry I only know simple SQL trying to learn more advance ones now.

NHK