Ok, easy question. I have a main table with say 10 fields. I have another table with the same field names (with the exception of a primary key field intelligently named "ID")
I have a lot of data in both, unfortunately, some of this data are dups
I need to sql statements:
1. joins both tables using field1, field2, field 3, field4, etc.
2. joins both but not duplicates
The first one is more important to me, but I could really use the second one too.
thanks in advance!