Help with joins

[#1]

Hi,

I am trying to join two tables

Basically everything in table 1 is exempt so these people dont need to be shown. And table 2 has a list of everyone. Im trying to join the two tables So that the people who have exemption dont appear. Could someone advise how i go about doing this.

Thanks in advance,

Kind regards,

Natalie

Table 1 (Exempt)
First Name
Surname
Location

Table 2
First Name
Surname
Locations

[vikasmahajan]

Select First Name,Surname,Locations

from table2

inner join table 1

where exempt < Condition>

Hope this helps

Vikas

[jvitantonio]

Hi, please use the following code

t1:

LOAD

autonumber([First Name]&[Surname]&[Location]) as Key, [First Name], Surname, Location

FROM ...

t2:

NOCONCATENATE

LOAD

autonumber([First Name]&[Surname]&[Location]) as Key, [First Name], Surname, Location

FROM ...

WHERE NOT EXISTS (Key);

Drop Table t1;

I hope this helps.

[#4]

Hi, Thank you for your response i have just tried this but it comes up with a field not found - <Key> error

[jvitantonio]

Make sure your field names are accurate. Otherwise please attach your application here so I can take a look at it.