Syntax Error in From Clause

[Annabelle]

Can someone please help me with the answer to the error "Syntax Error in FROM Clause":

SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM tbl_Reference_StandardFeatures INNER JOIN ([tbl_Join_Model&StandardFeature] LEFT JOIN tbl_Reference_PackageItemCC ON [tbl_Join_Model&StandardFeature].[FeatureID]=[tbl_Reference_PackageItemCC].[FeatureID]) ON [tbl_Reference_StandardFeatures].[ID]=[tbl_Join_Model&StandardFeature].[FeatureID]) LEFT JOIN tbl_Reference_UniqueChaparral ON [tbl_Join_Model&StandardFeature].[ModelID]="11" ORDER BY tbl_Reference_StandardFeatures.Feature, tbl_Reference_PackageItemCC.Item;

Thank you.

 

[Annabelle]

Now a Join Error Appears

I made a few changes and now I get the error "Syntax Error in JOIN Operation":

SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM tbl_Reference_StandardFeatures INNER JOIN (([tbl_Join_Model&StandardFeature] LEFT JOIN tbl_Reference_PackageItemCC ON [tbl_Join_Model&StandardFeature].[FeatureID]=[tbl_Reference_PackageItemCC].[FeatureID]) ON [tbl_Reference_StandardFeatures].[ID]=[tbl_Join_Model&StandardFeature].[FeatureID]) LEFT JOIN tbl_Reference_UniqueChaparral ON [tbl_Join_Model&StandardFeature].[ModelID]="11") ORDERBY tbl_Reference_StandardFeatures.Feature, tbl_Reference_PackageItemCC.Item;

All help is greatly appreciated. Thank you.

 

[Pat Hartman]

Add a where clause that checks for the specific value and remove it from the join. Use the QBE grid to build your joins.