SQL-从两个不同的表中选择行 [英] SQL - Select rows from two different tables

问题描述

有此表

Table "Items"

itemID
itemTitle
itemContent

还有这个

Table "MyList"

userID
itemID
deleted

即使给定了用户ID，即使itemID不存在于"MyList"中，如何从表"Items"中选择所有行并显示字段"deleted"?

how can I select all rows from table "Items" and showing the field "deleted", even if the itemID do not exist in "MyList", given an userID?

查询结果示例:

itemID | itemTitle | deleted | userID
-------------------------------------
1      | Title1    | 1       | 2
2      | Title2    | 0       | 2
3      | Title3    | (null)  | (null)
4      | Title4    | (null)  | (null)

查询是什么，以便我可以得到该结果?

What would be the query, so that I can get that result?

谢谢

推荐答案

我不确定这是否是最好的方法，但它会返回我正在寻找的内容:

I'm not sure if this is the best way of doing this, but it returns what I was looking for:

select itemID, itemTitle, deleted, userID
FROM(
SELECT i.id_itemID, i.itemTitle, M.deleted, M.userID
FROM
    MyList M
    right OUTER JOIN Items I ON I.itemID= M.itemID
) as MyTableItems
where itemID = 3 or itemID is null

这篇关于SQL-从两个不同的表中选择行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！