joining 3 tables RESOLVED

is there anything wrong with this query???
SELECT Employee.Name, Customer.Fname, PIHeader.* FROM PIHeader JOIN Employee ON PIHeader.EmployeeID = Employee.Employee ID JOIN (Customer ON PIHeader.CustomerID = Customer.CustomerID)

THIS IS RIGHT :)

hai,
what is ur need..can u explain it....

regards
Rajesh ^ ^
* *
()

Quote:

---

Originally Posted by pame1la

is there anything wrong with this query???
SELECT
Employee.Name,
Customer.Fname,
PIHeader.*
FROM
PIHeader JOIN Employee ON PIHeader.EmployeeID = Employee.Employee ID JOIN (Customer ON PIHeader.CustomerID = Customer.CustomerID)

---

Um nope... why?

EDIT: YES see bold bit
The bracket should be next to PIHeader.Cust...

Maybe :

Code:

---

SELECT
  Employee.Name,
  Customer.Fname,
  PIHeader.*
FROM
  (PIHeader LEFT JOIN Employee ON PIHeader.EmployeeID = Employee.Employee ID)
LEFT JOIN Customer ON PIHeader.CustomerID = Customer.CustomerID

---