Yea, I know it's been a while! Been totally swamped with work and hanging out with my signifacant other ;)..
Okay I know you are all not interested in my romantic life so I will go straight to the point.
I promise this will be quick.
If you want to join 2 tables A and B; and you want to see all the fields in table A but none in table B, and you don't want to list the columns (who can be bothered, right?), WELL.....
All you have to do is:
SELECT A.* FROM A JOIN B on A.id = B.id;
This will return all the fields contained in table A.
There you have it, guys!!!! I told you this would be quick!