Timeline for Compare two tables for discrepencies
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 3, 2023 at 19:37 | comment | added | SergeyA | Since your query returned ALL records in both datasets I guess you missed field order. Try to use field names instead of star. Try to limit queries with WHERE clause instead of all records. Your query looks correct | |
| Oct 3, 2023 at 7:13 | comment | added | QueryQuirk | The problem with defining a primary key is none of the columns can be made unique there are 14 columns in total, there are some like reference / surname etc. that would normally be ideally for a PK but there are duplicates because if all 14 columns are not exact match the system enters a new row. It is not our data we extract it from a 3rd party so don't have control of the input system | |
| Oct 2, 2023 at 15:43 | history | answered | SergeyA | CC BY-SA 4.0 |