Inner Join

Thu, 04 Jun 2009 15:57:08 GMT

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

Thu, 04 Jun 2009 16:04:31 GMT

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

topic Inner Join in QlikView