Left outer Join ???

[#1]

Hi All

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

A:

SQL SELECT

`New Code`,

`New Sub Code`,

`Office Name`,

`Office Number`,

FROM ` office codes`;

B:

SQL SELECT Month,

Office as [Office Number],

Week,

Year

FROM Total;

Thanks in advance.

[deepakk]

Hi,

A:

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.

[maneshkhottcpl]

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).

[#4]

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

[#5]

Many thanks for all your replies !!