Join 2 Tables via LEFT?? Is this Possible with QV

[#1]

Hi All,

I have just started to use QV and are looking at using google maps API which i have working.

I would like to know if it is possible to join 2 tables with different details example below.

Table 1

Short Postcode,latitude,longitude
AN23,555,444
DE45,344,344

joined to

Table 2

Full postcode,customer,
AN23 4TT,Bobs Butchers
DE45 2GF,Colins Clocks

Result would be:-
Bobs Butchers,AN23,555,444
Colins Clocks,DE45,344,344

Any help would be much appreciated.

Thanks
Mark

[#2 · Accepted solution]

Not tested but I think this will work for you…

Maintable:
LOAD
Short Postcode s [Short Postcode],
latitude,
longitude
FROM table source;

JOIN (Maintable)

LOAD
Left([Full post code],4) as [Short Postcode],
Customer
FROM table source;

COMBINEDTABLE
LOAD
Customer & Latitude & Longitude
RESIDENT Maintable;

[disqr_rm]

Here you go:

Tab1:
LOAD * INLINE [
Short Postcode,latitude,longitude
AN23,555,444
DE45,344,344
];

Left join (Tab1)
LOAD subfield([Full postcode], ' ',1) as [Short Postcode],
customer;
LOAD * INLINE [
Full postcode,customer,
AN23 4TT,Bobs Butchers
DE45 2GF,Colins Clocks
];