I have two rating/votes tables. One for user votes and stats and another for external votes. The external votes table always have data because it has a DEAFULT = 0, but the users votes only contains data if any user have voted for that specific ID.
Yani böyle bir şey yapın:
$sql = 'SELECT ratings_stats.votes, ratings_stats.total_value,
ratings_stats.view, ratings_stats.fav, ratings_stats.wish,
ratings_external.votes, ratings_external.total_value
FROM ratings_stats, ratings_external
WHERE ratings_stats.imdbID = ?
AND ratings_stats.imdbID = ratings_external.imdbID
LIMIT 1';
Ben sadece ikinci (dış oy) tablo oluşturmak değilse varsa OR iki tablodan verileri seçmek istiyorum.
Yeni bir sorgu yapmadan bunu nasıl yapabilirim?