How to Join 3 Tables

M

MT

Can someone help on SQL Syntax for how to Join 3 Tables ?
Thanks in advance.

(Variation taking from
Source: http://www.w3schools.com/sql/sql_join.asp,
this source show how to join 2 tables)


Vendors:
===========
Vendor_ID VName

11 HP
12 Cisco
13 IBM
14 Intel

Employees:
===========
Employee_ID Name

01 Hansen, Ola
02 Svendson, Tove
03 Svendson, Stephen
04 Pettersen, Kari

Orders:
============
Prod_ID Product Employee_ID

234 Printer 01 11
657 Table 03 12
865 Chair 03 13



Result to be
=================
Name Product VName

Hansen, Ola Printer HP
Svendson, Stephen Table Cisco
Svendson, Stephen Chair Intel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top