Closed. This question needs to be more focused。它当前不接受答案。
                            
                        
                    
                
                            
                                
                
                        
                            
                        
                    
                        
                            想改善这个问题吗?更新问题,使其仅通过editing this post专注于一个问题。
                        
                        5年前关闭。
                                                                                            
                
        
我想加入ID为2的表格。我写了以下查询,但出现错误。我想在mysql中同时选择所有列。

select t1.* t2.* table1t1
  JOIN table2t2
    ON t1.id = t2.postads_id
where ads_id=1277719543
  AND email='myemail@gmail.com';



  错误:#1064-您的SQL语法有错误;
      检查与您的MySQL服务器版本相对应的手册是否正确
      't1附近使用的语法JOIN nextpostads t2 ON t1.id = t2.postads_id其中
      ads_id = 1277719543 AND emai'在第1行


需要什么修改?

最佳答案

t1.*t2.*之间缺少逗号,并且没有FROM子句:

SELECT t1.*, t2.*
  FROM table1 t1
  JOIN table2 t2
    ON t1.id = t2.postads_id
 WHERE ads_id = 1277719543
   AND email = 'myemail@gmail.com'


另外,请尝试使用所有关键字的大写字母或小写字母,但不要混用。

关于mysql - 联接查询问题,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/3186522/

10-11 05:22
查看更多