I have 4 tables that need to be joined. I want the first two tables to select records as follows:
The first table records the purchase info, the second table is an itemized list containing and id entry from the purchase table and the item number. This table can have multiple entries (M-M).
From the itemized table I want to select a record for each purchased item BUT I do not want any item repeated more than once. In other words, two purchases made by one customer could contain the same item. I do not want the item repeated.
How do you build a select wihch does this.
More on the other two tables if I can't figure out the rest after this is solved.
