Select to include table.column with inner join?

Databases
1

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?

2

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

example –

SELECT customers.id [COLOR="#0000FF"]AS cust_id[/COLOR]
     , orders.id [COLOR="#0000FF"]AS order_id[/COLOR]
  FROM customers
INNER
  JOIN orders
    ON orders.customer_id = customers.id
3

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

4

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