syntex error

[annub]

I am getting syntex error 'Missing operator' in this query
SELECT DISTINCT
dbo.ttdilc101201.t_clot AS Lot, dbo.ttdilc101201.t_cwar AS Warehouse, dbo.ttdilc101201.t_cprj AS project, dbo.ttdilc101201.t_date AS ItemDate,
dbo.ttdilc101201.t_item AS Item, dbo.ttiitm001201.t_dsca AS ItemDscp, dbo.ttipcs021201.t_dsca AS CustDsca,
dbo.ttdilc101201.t_strs AS Inv_on_hand_stora, dbo.ttdilc101201.t_stkb AS Inv_on_hold, dbo.ttdilc101201.t_loca AS location,
dbo.ttipcs021201.t_item
FROM dbo.ttdilc101201 LEFT outer JOIN
dbo.ttipcs021201 ON (dbo.ttdilc101201.t_item = dbo.ttipcs021201.t_item) LEFT outer JOIN
(dbo.ttiitm001201 ON dbo.ttdilc101201.t_item = dbo.ttiitm001201.t_item)
WHERE (dbo.ttdilc101201.t_strs > 0) AND (dbo.ttdilc101201.t_loca = 'BULK STO')

Thanks

 

[RoyVidar]

Hi!

First that springs to mind, is the "outer" words in the From clause of the SQL. I think the Access SQL syntax is only 'LEFT JOIN' or 'RIGHT JOIN' for outer joins.

You haven't specified where/how you're using this.

I'm not able to give any more specific help, I'm afraid. You could "play" a little with the join properties in the query grid (right click the relationship, select Join Properties).

Risk is the message "...SQL statement could not... contains ambigous outer joins..." - the tip included in that error message is to "create a separate query that performs the first join and then include that query in your SQL"

Else, you might also try posting in the SQL/Query forum (forum701)

HTH Roy-Vidar