SELECT `Order`.`Account` AS Account ,`Order`.`OrderNumber` AS OrderNo
,`TWOrder`.`Customer` , `TWOrder`.`WorksOrderNumber`, `TWOrder`.`Product`,
`Stock`.`ProductNumber`, `Stock`.`Description` AS description
,`Bundle`.`WorksOrder`,`Bundle`.`WorkSection` FROM Order, TWOrder, Stock, Bundle, WHERE
`Order`.`Account` = `TWOrder`.`Customer` AND`TWOrder`.`WorksOrderNumber` =
`Bundle`.`WorksOrder` AND `TWOrder`.`Product` = `Stock`.`Description` AND
 `Order`.`Account` = '337447'


我检查并发现了明显的错误,但我似乎看不到错误。会欣赏另一双眼睛

最佳答案

您在错误的位置输入了逗号-我认为这应该有效(并且可读性更高)

    SELECT `Order`.`Account` AS Account,
           `Order`.`OrderNumber` AS OrderNo,
           `TWOrder`.`Customer`,
           `TWOrder`.`WorksOrderNumber`,
           `TWOrder`.`Product`,
           `Stock`.`ProductNumber`,
           `Stock`.`Description` AS description,
           `Bundle`.`WorksOrder`,
           `Bundle`.`WorkSection`
   FROM `Order`, TWOrder, Stock, Bundle
   WHERE
    `Order`.`Account` = `TWOrder`.`Customer` AND
    `TWOrder`.`WorksOrderNumber` = `Bundle`.`WorksOrder` AND
    `TWOrder`.`Product` = `Stock`.`Description` AND
    `Order`.`Account` = '337447'

关于mysql - mysql 1064错误无法发现明显错误,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/9231332/

10-16 08:06