what is the proper syntax for the following query:
Code:
colours.Source = "SELECT productfam, productid_img, ColourAtt1, ColourAtt2, ColourAtt3, sub, FROM images WHERE productid_img = MMColParam OR (ProductFam=1) OR (sub=10) AND (Not IsNull(ColourAtt1)or Not IsEmpty(ColourAtt2)) ORDER BY sort_img_prd DESC"