MySQL INNER JOIN table2에서 열 선택

INNER JOIN 을 사용하여 두 번째 및 세 번째 테이블에서 특정 열을 선택하려면 어떻게해야합니까?

SELECT 
    *
FROM
    1_packages_plu AS p
        INNER JOIN
    1_stock as s ON p.fk_products_id = s.fk_products_id
        AND branch = 1
        INNER JOIN
    1_products AS j ON p.fk_products_id = j.id
WHERE
    fk_packages_id = 54;

1_stock 테이블에서는 stock-repair 열의 값만 반환하고 1_products 에서 필요한 것은 make, model 열입니다.

 

해결 방법

 

SELECT
    p.* -- All columns from p
    ,
    s.columnName -- Just that column from s
    ,
    j.columnName -- And just that column from j

FROM
    1_packages_plu AS p

    INNER JOIN 1_stock as s
        ON p.fk_products_id = s.fk_products_id
        AND
        branch = 1

    INNER JOIN 1_products AS j
        ON p.fk_products_id = j.id

WHERE
    fk_packages_id = 54

 

참조 페이지 https://stackoverflow.com/questions/14068780