topic Left outer Join ??? in QlikView

Left outer Join ???

Tue, 14 Dec 2010 11:25:09 GMT

Hi All

I need to Join 'Office Number' in A table with 'Office' in B table. How can I do left outer Join ??

SQL SELECT

`New Code`,

`New Sub Code`,

`Office Name`,

`Office Number`,

FROM ` office codes`;

SQL SELECT Month,

Office as [Office Number],

Week,

Year

FROM Total;

Thanks in advance.

Left outer Join ???

deepakk — Tue, 14 Dec 2010 11:42:24 GMT

Hi,

SQL SELECT

`New Code`,

`New Sub Code`,

`Office Name`,

`Office Number` as [Office Number],

FROM ` office codes`;

left join

SQL SELECT Month,

Office as [Office Number],

Week,

Year

FROM Total;

I hope this helps you out.

Left outer Join ???

maneshkhottcpl — Tue, 14 Dec 2010 11:48:49 GMT

Hi, The Use of join is depend on situations, The left join used for full left data and matched right data.

It is used to join Master table (Secondary) with Transaction table(Main).

Left outer Join ???

Tue, 14 Dec 2010 11:50:36 GMT

Hi,

A:
load
`New Code`,

`New Sub Code`,

`Office Name`,

`Office Number`;
SQL SELECT *
FROM ` office codes`;

left join

load
Month,

Office as [Office Number],

Week,

Year;
SQL SELECT *

FROM Total;

Regards,

Ravi

Left outer Join ???

Tue, 14 Dec 2010 17:40:36 GMT

Many thanks for all your replies !!