Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1 (Exempt) |
---|
First Name |
Surname |
Location |
Table 2 |
---|
First Name |
Surname |
Locations |
Select First Name,Surname,Locations
from table2
inner join table 1
where exempt < Condition>
Hope this helps
Vikas
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.
Hi, Thank you for your response i have just tried this but it comes up with a field not found - <Key> error
Make sure your field names are accurate. Otherwise please attach your application here so I can take a look at it.