
January 13th, 2000, 07:58 PM
|
|
Junior Member
|
|
Join Date: Jan 2000
Posts: 20
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
I am trying to do a query that requires an inner join of 4 tables then left join to a 5th table.
Here is my query:
SELECT s.Time, s.Amount, u.LastName, u.FirstName, u.HAddress_1,
u.HCity, u.HState, u.HZip, i.SKU, a.Owner, p.Value AS Local_Assn
FROM (SalesOrders s, Users u, SalesItems i, Accounts a) LEFT JOIN Preferences p ON (u.User = p.User)
WHERE s.SalesOrder = i.SalesOrder
AND s.Account = a.Account
AND a.Owner = u.User
AND p.Attr = 'assoc1'
AND s.Status = 'completed'
AND i.SKU LIKE 'car%'
ORDER BY s.Time
Quite a mouthful. The query runs, but gives an inner join on all 5 tables. Where am I going wrong with my syntax?
|