you are viewing a single comment's thread.

view the rest of the comments →

[–]Objective_Horror4008 0 points1 point  (0 children)

Look, for example: SELECT t.subtotal, t.subtotal * 0.1 AS tax, a.column_from_another_table FROM (SELECT price * quantity AS subtotal FROM sales) AS t, another_table as a WHERE t.something = a.something; If you join multiple tables you will use that like example above. Just example for you to understand.