Need help? Call 800-511-MACS (6227)

Error: Unable to perform query: select A.ProductB, A.weight from ProductSuggestions as A, products as B where A.ProductA = 44416http: and A.ProductB = B.FilemakerRecordID and (B.Qty > 0 or B.StockingStatus<>'' or ( B.ArrivalDate <> 0000-00-00 and B.QtyInRoute > 0)) order by weight :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 ': and A.ProductB = B.FilemakerRecordID and (B.' at line 3