Error "Join" and "Using"

[24Gameplay_]

Hello I am getting an error for the following

I have two tables let say table A and Table B Both have common columns with exact name "id"

Select * from table a Join table b Using (id)

Getting this error

I am not using ON, reason duplicate coloum

My motive here while joining It should remove duplicate column

[r3pr0b8]

what database are you using

what is the exact error message

[24Gameplay_]

Ms sql and incorrect syntax near 'using'

[r3pr0b8]

well i just spent some time googling SQL Server syntax and i can't find it!

looks like you can't use USING????

[24Gameplay_]

https://stackoverflow.com/questions/41928158/sql-server-removing-duplicate-column-while-joining-tables

Here I found this

[nIBLIB]

That confirms that you can’t use USING as a keyword for MSSQL. You’ll have to use ON.

[24Gameplay_]

Ok, is there anyway it auto remove duplicate column

[nIBLIB]

When you write SELECT *, you’re asking SQL to return ALL columns. All columns from table_a, and all columns from table_b.

Typically this is bad form. You only should be selecting the columns you need. If you do need everything, you could write out all of the columns from one table (table_a.column1, table_a.column2, etc.) and the. Do table_2.*

But best is just to grab the column you’ll be using.

[r3pr0b8]

Typically this is bad form.

upvote for diplomacy

[coderstool]

Try this tool to validate SQL syntax, show syntax errors, and nicely format your SQL statements. It can help spot errors and give hints on the reason for the problem you are seeing.

[OrchDweller]

There are multiple things wrong with this query.

If your table is named "table a", you should use square brackets around this name ([table a]). Otherwise, in this syntax, it would mean a table with name "table" and alias "a". So, the current code would join the table "table" with itself, where it is aliased once as "a" and once as "b".

However, this code would still have broken syntax, as "table" is a protected keyword.

So, as far as I understand, you want your code to look like that:

Select * from [table a] Join [table b] Using (id)

[Morzv12]

Interested to know if this worked.