I want to select all the fields from one table and also some specific fields from other tables using `LEFT JOIN`. Can I use the \* to select all the columns from the one table and also name the specific fields from the `JOIN`?

Something like this:

```
SELECT * , table2.a, table2.b 
FROM table1
LEFT JOIN table2 ON table2.a = table1.a
WHERE ...

```