SQL join large table with only select columns from two other tables

Question

I want to join three tables (with many columns each). From the first table I need all columns. From the second and third table I only need a few columns each.

How can I join the three tables without having to type out all needed column names in my select statement? I understand that I will type out the needed column names for the 2nd and 3rd table. However, for the first table I would like to use select *.

Please provide a minimal reproducible example with sample data, desired results and your attempt. Also please tag your RDBMS. — Dale K
– Dale K, Commented May 1 at 10:04
FYI... its best practise to always type out all columns. Relying on select * often leads to future issues. — Dale K
– Dale K, Commented May 1 at 10:05
But the answer is probably just select t1.*, t2.col1, t2.col2 etc — Dale K
– Dale K, Commented May 1 at 10:06

tdy · Accepted Answer · 2025-05-01 13:59:35Z

1

SELECT p.*, c.description, s.company_name
from products p
join categories c on p.category_id = c.category_id
Join suppliers s on p.supplier_id = s.supplier_id

edited May 1 at 13:59

tdy

42k42 gold badges124 silver badges125 bronze badges

answered May 1 at 10:09

Ganesh Mohane

427 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL join large table with only select columns from two other tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related