sql，带有内部联接的sqlite SELECT [英] sql, sqlite SELECT with inner join

问题描述

我想知道如何使用内部联接或其他方式两次选择一列.我的数据库是sqlite，并且我使用PDO db驱动程序.

I'm wondering how to select one column twice using an inner joinor some other way. my database is sqlite and i use PDO db driver.

我的例子:

    SELECT
            orders.id,
            orders.order_number,
            clients.first_name,
            clients.last_name,
            users.name AS user_name
    FROM orders

    INNER JOIN clients ON
            orders.client_id = clients.id

    INNER JOIN users ON
            orders.created_by = users.id

我还想获得编辑此记录的用户名

I want to get also, the user_name who edited this record

            orders.edited_by = users.id

如何加入此选择?

推荐答案

您将需要使用表别名.

SELECT
        orders.id,
        orders.order_number,
        clients.first_name,
        clients.last_name,
        creator.name AS creator_user_name
        editor.name AS editor_user_name
FROM orders

INNER JOIN clients ON
        orders.client_id = clients.id

INNER JOIN users creator ON
        orders.created_by = creator.id

INNER JOIN users editor ON
        orders.edited_by = editor.id

这篇关于sql，带有内部联接的sqlite SELECT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！