I would like to do a left outer join of table A and B with key ID, so that I can get all fields in table A and one field from table B.
However I found it seems I have to list all fields in table A one by one in the SELECT, but I have many fields in table A....
Is there any easier way instead of listing all the fields out?
I tried A~*...but of course it doesn't work.. 😔