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/