Question

下面请问:

$sql = "SELECT `scanners`.`KordNo`, `scanners`.`BundleNumber`
  FROM `scanners`, `TWOrder`, `Stock`
  INNER JOIN `TWORDER` ON `scanners`.`KordNo` = `TWOrder`.`KOrdNo`
  AND `scanners`.`Date` =  " . $date . " 
  INNER JOIN `Stock`  ON `TWOrder`.`Product` =`Stock`.`ProductCode`
  AND `Stock`.`ProductGroup` NOT BETWEEN 400 AND 650  
  AND `scanners`.`Scanner` IN (
  ORDER BY `scanners`.`KordNo` ASC";
  foreach($scanner as $x) 
  {$sql .= $x . ",";}
   $sql .= "0);";
  // And query the database
  $result = mysql_query($sql);
  while($row = mysql_fetch_array($result))
  $return[] = $row;
}

当我回合在营地的舱面时,我的行政就没有独一无二的桌子/别;;

谁可以告诉别人?

Answer 1

由于你重新使用JOIN,将另外两个表格从条款中删除。

...
FROM `scanners`
INNER JOIN `TWORDER` ON `scanners`.`KordNo` = `TWOrder`.`KOrdNo`
...

Answer 2

页: 1

FROM `scanners`, `TWOrder`, `Stock`

之后,你们有一些INNER JOINs on to TWOrder and Stock。

That s mixing syntax (, and JOIN) which is messy. Stick to JOIN
It means that TWOrder and Stock are mentioned Twice in the query

如果你需要把这张表格多次列入一个询问,你需要给他们别名,以便彼此脱节。

但我认为,这很可能是一个错误,第2行应当只是一个错误。

FROM `scanners`

www.un.org/Depts/DGACM/index_spanish.htm

之后,我也不知道你如何汇编。页: 1 您应在填满时段之前附上该名单,然后在你结束座椅之后附上。

友情链接