Query Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[t] AND tblDesigner.Designer_ID = tblProduct.Designer_ID' at line 5

The query attempting to execute was:
SELECT Product_ID, Code, Subject_ID, Designer, tblProduct.Designer_ID, Title, Description, Width, Height, Color, ImageMain, ImageModel, IF(StitchGuide = -1,'Yes','No') as StitchGuide FROM tblProduct, tblDesigner WHERE Product_ID = [t] AND tblDesigner.Designer_ID = tblProduct.Designer_ID

Script failed on line 51