打印联合选择

Question

我有以下查询：

$query = mysql_query("  ( SELECT naam 
                          FROM users_social 
                          WHERE user_id = 1 )
                        UNION 
                        ( SELECT COUNT(DISTINCT DATE(datetime)) as days 
                          FROM users_social_invoer 
                          WHERE user_id = 1 )"
                    );

现在，我可以使用以下echo回显查询的第一部分( 'naam')：

echo mysql_fetch_row($row_query[0]);

然而，echo‘’ing $row_query1并不像我想要的那样打印出查询的第二部分(联合选择)。我如何实际打印出查询的这一部分？谢谢

Answer 1

您需要JOIN而不是UNION

SELECT us.naam, count(DISTINCT DATE(usi.datetime)) as days
FROM users_social as us
JOIN users_social_invoer as usi
  ON us.user_id = usi.user_id
WHERE us.user_id = 1    
GROUP BY us.naam