php - mysql表加入并使用DISTINCT

Closed. This question needs details or clarity。它当前不接受答案。
                            
                        
                    
                
                            
                                
                
                        
                            
                        
                    
                        
                            想改善这个问题吗？添加详细信息并通过editing this post阐明问题。
                        
                        5年前关闭。
                                                                                            
                
        
我在MySQL中使用DISTINCT以及连接表时遇到问题。

我有2个表：tapplicant和toutcome它们共享一个APPID，这就是我想要加入它们的方式。

我查询了tapplicant表，它工作正常，我只需要从toutcome表中找到1个称为“ Status”的列

我也在查询中使用DISTINCT，因为我不希望显示任何重复的结果。以下是我的查询

SELECT DISTINCT tapplicant.AppDate, tapplicant.Title, tapplicant.FirstName, tapplicant.LastName, tapplicant.Email, tapplicant.Postcode, tapplicant.AppIPAddress, toutcome.Status
FROM tapplicant
INNER JOIN toutcome
ON tapplicant.AppAffID = toutcome.affID;

最佳答案

尝试这个：

SELECT tapplicant.AppDate, tapplicant.Title, tapplicant.FirstName,
tapplicant.LastName, tapplicant.Email, tapplicant.Postcode,
tapplicant.AppIPAddress, toutcome.Status FROM tapplicant
INNER JOIN toutcome
ON tapplicant.AppAffID = toutcome.affID;
GROUP BY tapplicant.AppDate, tapplicant.Title,