I would like to select data from two tables, while left join them. How can I select all fields from table1 and only specific from table2?
"SELECT table1.*, table2.field1, table2.field2 etc." then the rest of the query
Yes, thanks. I just tried that way and it works fine. I wasn't sure I could use wildcard in this case.
