显示查询中的表名

Question

我有一个SELECT separate，其中我连接了两个不同的表。

$result = mysql_query('SELECT * FROM (SELECT * FROM gslil0009) as table1 UNION SELECT * FROM (SELECT * FROM gslil0028) as table2' . ' ORDER BY lname');

while($row = mysql_fetch_array($result)) {
  echo $row['fname'];
}

如何打印出行来自哪个表？

Answer 1

$result = mysql_query('SELECT *,'tbl1' FROM (SELECT * FROM gslil0009) as table1 
               UNION SELECT *,'tbl2' FROM (SELECT * FROM gslil0028) as table2' 
               . ' ORDER BY lname');

while($row = mysql_fetch_array($result)) {
  echo $row['fname'];
  echo $row['tbl1'];
}

Answer 2

我使用了与sel相同的解决方案，只是添加了反斜杠以避免错误，并在表名中添加了一个名称。

$result = mysql_query('SELECT *,\'table1\' AS tablename FROM (SELECT * FROM gslil0009) as table1 
               UNION SELECT *,\'table2\' AS tablename FROM (SELECT * FROM gslil0028) as table2' 
               . ' ORDER BY lname');

while($row = mysql_fetch_array($result)) {
  echo $row['fname'];
  echo $row['tablename'];
}

我无法对他的帖子发表评论。