Thank you both!

The report is working excellent now!

this is my final code...

SELECT

S.Sstatus as 'Status',

S.TICKETNUM as 'Receipt',

S.DATEin as 'Sold On',

S.INVNUM as 'SKU1',

S.TicketNum as 'Ticket',

S.Cost as 'Cost',

S.Amount as 'Amount',

I.NEWITEM as 'Condition',...

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

I changed them all...

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

I changed them all 😉

this is my final...

I changed them all 😉

this is my final query:

SELECT

S.TICKETNUM as 'Receipt',

S.DATEin...

drew.allen (5/27/2016)

---

Looking at your queries, it looks like you may not realize that you can join to the same table multiple times as long as they have different aliases.

SELECT *

FROM...

With the 1st report I get something like this:

SELECT

i.ITEMS_PK as 'SKU 1',

i.INVNUM as 'SKU 2',

i.OWNERNUM as 'Online SKU',

i.NEWITEM as 'Condition',

i.BIN as 'Location',

k.DESCRIPT as 'Online Status',

h.DESCRIPT...