Inner Join

[#1]

Good Morning,

i have to create an INNER JOIN between 2 tables in the same databeses.

The name of the field are different.

I have tried to do the INNER JOIN operation in the script, i have follow the manual instruction, this is the query that i wrote

SQL

SELECT

CodiceProdotto

FROM

Database1

SELECT

Codice

FROM

I don't be able to insert the operator CodiceProdotto = Codice.

How i can do this??

Thak YOU

Database1

[#2]

Hi,

Try the below script and let me know if this works or not.

Tab1:

SELECT CodiceProdotto as codice FROM table1;

INNER JOIN

Tab2:

SELECT Codice FROM table2;

Another way:

SELECT CodiceProdotto FROM table1T1 JOIN Table2 T2 ON T1.CodiceProdotto = T2.Codice

Note that both the joining column should be in same datatype

-Raghu