merging two tables with same columns and with info overlapping

[Pico]

Hi all,

I have two tables with the same columns (refName, refMail, refNum, Furnisher, ...) and many overlapping rows. (the tables are from different years, and many rows are identical in all years)

How can I concatenate the two tables without duplicating the identical rows?

The ideal situation is not to load the identical rows, that are 80% of the second table...

Thank you

P

[marcus_sommer · Accepted solution]

You may just use: load distinct * from ...; whereby if the tables are from different years could a entire record be duplicated?

- Marcus

[Pico]

wow, is just that simple 🙂 nice!

There is no field "year" in the table, simply the seller is the same from year to year, with the same mail, name, cell number, etc..