INNER JOIN

[yehlu]

遇到一個怪問題

SELECT e_news_articale.*,users.* FROM e_news_articale INNER JOIN users ON e_news_articale.modify_user = users.user_id ORDER BY e_news_articale.e_news_articale_id desc LIMIT 0,10;

只有一筆資料

SELECT e_news_articale.* FROM e_news_articale INNER JOIN users ON e_news_articale.modify_user = users.user_id ORDER BY e_news_articale.e_news_articale_id desc LIMIT 0,10;

只有一筆資料

SELECT e_news_articale.modify_user ,users.* FROM e_news_articale INNER JOIN users ON e_news_articale.modify_user = users.user_id ORDER BY e_news_articale.e_news_articale_id desc LIMIT 0,10;

有5筆資料

SELECT users.* FROM e_news_articale INNER JOIN users ON e_news_articale.modify_user = users.user_id ORDER BY e_news_articale.e_news_articale_id desc LIMIT 0,10;

有5筆資料

只要用 e_news_articale.* 就只有一筆資料
不知是什麼問題,再查查吧