hi all
i was wonder if its possible to join 3 tables, so i could see the result from the 3 tables.
for example
lets say that i have
INVOICE(invoice_id, client_id,item_id)
CLIENTS(id, client_name)
ITEM(item_id, item_name)
i want 1 table that shows: invoice_id, client_name,item_name
is this possible?
10x!
severman
0
Junior Poster in Training
Recommended Answers
Jump to PostHow your tables are linked to each other ?
I don't think they are.
Jump to PostHow your tables are linked to each other ?
I don't think they are.
INVOICE(invoice_id, client_id,item_id)
CLIENTS(id, client_name)
ITEM(item_id, item_name)I think he/she will have to client_id with id on client and Invoice then union on ITEM.item_ID = INVOICE.Item_ID
All 9 Replies
finito
46
Nearly a Posting Virtuoso
debasisdas
580
Posting Genius
Featured Poster
finito
46
Nearly a Posting Virtuoso
severman
0
Junior Poster in Training
severman
0
Junior Poster in Training
finito
46
Nearly a Posting Virtuoso
karant
0
Newbie Poster
karant
0
Newbie Poster
mrahil2008
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.