SQL Join Everything From One Table With One Feild From Another Table?

Question

Is there a way to specify a join on all fields from table A with only one field from table B?

Is it necessary to specify each individual field from each table instead of using the all symbol (*) for one of the tables?

Answer 1

I think you want to:

select tableA.*, tableB.someField