Recent content by Herie

  1. H

    How to avoid Cartesian Joins

    Thanks recyan. to 1) correct, currently only 2 tables are connected because of the issue of multiplying the entries. to 2) I requested to have a field in each table included which would have a primery key from a 4th table (travellers unique profile id) and I am hoping this will solve the...
  2. H

    How to avoid Cartesian Joins

    I receive various data from an outside source to create reporting. Unfortunately non of this excel table has a primary key. I have to connect the data via 'booking ID' field which has in all 3 tables muliple entries. I entered SELECT DISTINCT in the SQL script. When I add the required fields...
Back
Top Bottom