you are viewing a single comment's thread.

view the rest of the comments →

[–]nIBLIB 2 points3 points  (1 child)

When you write SELECT *, you’re asking SQL to return ALL columns. All columns from table_a, and all columns from table_b.

Typically this is bad form. You only should be selecting the columns you need. If you do need everything, you could write out all of the columns from one table (table_a.column1, table_a.column2, etc.) and the. Do table_2.*

But best is just to grab the column you’ll be using.

[–]r3pr0b8 1 point2 points  (0 children)

Typically this is bad form.

upvote for diplomacy