Inner join with dozens of records from one table
I have a SELECT * Query on a php page because I actually need all columns and it would have been far too much work to list each column individually.
Now though, I need to do an Inner Join to include 3 columns from another table.
Normally I would do something like:
SELECT table1column1, table1.column2, table2 column1 FROM table1 INNER JOIN table2 ON ....
Can I do this using SELECT * on the first table rather than listing out each column separately?