我试图从6个表中产生一个查询,它应该显示标题,生产年份和它在所有类别中赢得的奥斯卡奖总数。我之前尝试加入他们,但在某些类别(例如actor_award,根本没有'Oscar‘条目,在其他表格,如crew_award 'Oscar’被输入7次),我产生的代码不能工作,但我认为它是我试图实现的伪代码。有人能帮我吗?WHERE
(SELECT * FROM actor_award WHERE actor_award
我有两个表,奖励和awards_user,并且在mysql查询上的左联接有问题没有得到我想要的结果。(" SELECT awards.name as name, awards.link as link, FROM awards LEFT JOIN awards_user ON (awards_user.awardid = <em
, awards.featured AS awards_featured, awards_awards_categories_1.id AS awards_awards_categories_1_id,awards_awards_categories_1.award_id AS awards_awards_categories_1_award_id, awards_awards_c