What type of statement do I need here?

[affmark]

Hello, first I apologize if this has been answered already. I couldn't find the answer I need by doing a forum search.

Anyway, I have two similar tables. They both contain the same fields and some of the records may be identical. My question is what type of select statement do I need to use to find all of the records from both tables and not have any duplicates in the results. I have tried several different methods and none have returned the results that I need.

Is this even possible?

Thanks

[affmark]

Never mind. I think I need a UNION statement here. At least, I THINK that's it.

[longneck]

you could do it with a union if you're on mysql 4.1 or newer. otherwise a left join is called for.