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
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