sql - perform join excluding repeated fields-CodePudding

I have the following problem, I use sql server, I need to join two tables by a field, but when performing the join I am duplicating the key field, my query is as follows:

select A.*, B.*
from Database.dbo.Module1 A
LEFT JOIN RRHH.dbo.Module2 B on A.key1 = B.key1

is it possible to exclude from the select the key1 field from the module2 table?

In the tables, I have another few duplicate fields, I could write every field I need from the tables in the select, but , it would be easier to exclude the fields I don't need. Consider that each table has hundreds of fields that are needed.

CodePudding user response：

It is impossible. Specify fields you need.

CodePudding user response：

There is no "all columns except <these>" syntax in T-SQL, sorry.

Of course it's very easy to generate the list of columns from any table by simply dragging the Columns node onto a query window. This works in both SSMS and Azure Data Studio, as I describe

Then just prefix the ones you need, and delete the ones you don't.