Hi Guys,
After hours of trial and error, all errors, I cannot for the life of me figure out how to join data from two different tables.
Table 1 has INVOICE NUMBER, CUSTOMER NAME, and CUSTOMER EMAIL, one Invoice Number per row.
Table 2 has several rows with the same Invoice Number, and one item on each row. So, if the customer just bought one item, there would be only one row with Invoice Number and Item.
If customer bought three items, there would be three rows, with the same invoice number on each row and one item per row in the Item field.
What I want to do is to build a THIRD table that has Name, Email address, and Item, so I can then sort who bought a specific item, or all the items a specific client bought.
But try as I will, I can't figure out how to do it and ANY help would be VERY appreciated.
So, Table 1:
Invoice 1 - Client 1 - Client Email 1
Invoice 2 - Client 2 - Client Email 2
Table 2 has
Invoice 1 - Item 1
Invoice 1 - Item 2
Invoice 2 - Item 3
Invoice 3 - Item 1
Invoice 3 - Item 5
Invoice 3 - Item 6
What I would like is
Client 1 - Item 1
Client 2 - Item 2
Client 2 - Item 3
Client 3 - Item 1
Client 3 - Item 4
I hope this makes sense. THANK YOU in advance!!!