Table of Contents
select
t.transaction_id
,t.line_item_number
,t.transaction_date
,t.customer_id
,t.product_id
,t.sale_amount
,t.sale_amount
,t.quantity
,c.gender
,c.state
,c.first_name
,c.last_name
,c.email_address
,c.dob
,c.street_address
,c.date_created
,c.create_source
,p.pieces
,p."cost"
,d.product_description
,co.color_desc
,m.material_desc
from transactions t
inner join customers c on c.customer_id = t.customer_id
inner join products p on p.product_id = t.product_id
inner join descriptions d on d.description_id = p.description_id
inner join colors co on co.color_id = p.color_id
inner join materials m on m.material_id = p.material_id
