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

Is there a way to specify a join on all fields from tab开发者_JS百科le 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?

I think you want to:

select tableA.*, tableB.someField