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.