Left Join Help !!

[#1]

Hi,

I need to do Left Join for these tables.

My requirement is Country from left table and Latitude & Longitude from right table.

Let me know, how to do this in editor.

[jagan]

Hi,

Try like this

Customer:

LOAD

*

FROM Customer;

LEFT JOIN (Customer)

LOAD

*

FROM Latlng;

both the tables joined based on the Country.

Regards,

Jagan.

[#3]

Can try like this:

Table1:
Load Country
from customertable

Left join (Table1)

Load Country,Latitude,Longitude
from LatLng;

By default the tables will be joined on Country. If you want all the fields then you can use * instead of particular field names.

Hope this helps!

[amit_saini · Accepted solution]

Hi Murali,

Try this:

Table1:

LOAD *,

FROM

Customer_table;

Left Join(Table1)

LOAD *,

FROM

LatLong;

Country will be become Primary key during this join.

Thanks,

AS

[vijetas42]

Hi,

You can write script as,

CustomerTable:

LOAD Customer

From CustomerTable ;

LEFT JOIN(CustomerTable)

LatLng:

LOAD *

From LatLng ;

Hope this will help you

Regards,

Vijeta

[MK_QSL]

Load * From customertable;

Load * From LatLng

Where Exists (Customer);

[#7]

thanks for your responses !! I got it.

[MK_QSL]

Kindly close the thread by selecting appropriate answer.

[#9]

Hi Saini,

Thanks it worked finally !!