当run title_two和author_two没有被下一个标题值正确填充时,我的select语句遇到了问题。相反,它们会打印出与b.title和b.author相同的内容。我尝试将它们声明为
`B.title AS title_two`.
SELECT R.bookone, B.title, B.author,
R.booktwo, B.title title_two, B.author author_two,
R.relation, R.relationlike, R.relationdislike
FROM relationships R
INNER JOIN books B ON R.bookone = B.bookid;有两张桌子
具有以下关系的关系: relationshipid、bookone、booktwo、relationship、relationlike、relationdislike
然后是bookid、title、author、publisher
bookone和booktwo是引用bookid的外键,我试图获得的是拥有它,这样当用户单击一个链接时,它就会显示出这本书与其他书之间的所有关系
发布于 2012-05-22 15:37:39
使用别名时使用引号
SELECT R.bookone, B.title, B.author,
R.booktwo, B.title as 'title_two', B.author as 'author_two',
R.relation, R.relationlike, R.relationdislike
FROM relationships R
INNER JOIN books B ON R.bookone = B.bookid;发布于 2012-05-22 15:38:01
你需要在书上再加入一次。类似于:
SELECT R.bookone, B1.title, B1.author,
R.booktwo, B2.title title_two, B2.author author_two,
R.relation, R.relationlike, R.relationdislike
FROM relationships R
INNER JOIN books B1 ON R.bookone = B1.bookid
INNER JOIN books B2 ON R.booktwo = B2.bookid发布于 2012-05-22 15:39:09
他们正在做他们应该做的事情。author_two应与B.author相同,title_two应与B.title相同。它们只是别名。
此外,从单个表中请求两次相同的列不会得到表中的下一个结果--它只返回相同的列两次。
https://stackoverflow.com/questions/10697668
复制相似问题