INNER JOIN Select columns from table2

Question

How to select specific columns from second and third tables using 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; 

In 1_stock tables 1_stock I only want to return the values ​​of the stock-repair columns, and in 1_products all I need is make, model columns

Answer 1

 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 

Answer 2

To access a column, an operator is required. (.):

 SELECT p.* , s.stock-repair, j.make, j.model 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 ORDER BY p.colunmname ; 

Answer 3

 SELECT Table1.*, Table2.FK, Table2.SomeColumn, Table2.SomeColumn, Table3.SomeColumn, Table3.SomeColumn FROM Table1 INNER JOIN Table2 ON Table1.FK = Table2.Table1FK INNER JOIN Table3 ON Table2.FK = Table3.Table2FK