joining 3 tables RESOLVED

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

THIS IS RIGHT

[smartrajesh]

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

regards
Rajesh ^ ^
* *
()

[Ecniv]

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 :

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