Select to include table.column with inner join?

[Gooofy]

When joining two tables and they each have the same column name "id", the result will include data for both "id" columns in both tables.
I would like the select statement to produce the list of columns with the table name prefixed:
report.id, report.status, status.id, status.name

Possible?

[r937]

yes, possible, but not with the dots, rather, using column alias names

example --

SELECT customers.id AS cust_id
     , orders.id AS order_id
  FROM customers
INNER
  JOIN orders
    ON orders.customer_id = customers.id

[Gooofy]

What if I want this generically, meaning, I want to get all columns like that.
Can I use the wild card '*'?

[r937]

Can I use the wild card '*'?

no, that wouldn't allow you to assign aliases, you have to write them all out