Using Exist or Left Join

[#1]

I have two resident table

Table 1 has a list of Controlling Areas

          Key field is A

Table 2 has Controlling Area data

     Key field is %$CO_Area

I want to create another table from Table 2 if the A exists in Table 2.

I tried

Resident Table 2

     where exists(%CO_Area,A) ;

I am getting a syntax error that A does not exist.  

[buzzy996]

seems here A existing in Table1?right

[#3]

Yes you are correct A is in Table 1, and I only want to pull data from table 2 if the CO Area is in Table 1

[anbu1984 · Accepted solution]

Change order in Exists()

Resident Table 2

     where exists(A,%CO_Area) ;

[buzzy996]

can u try Applymap() here?

[#6]

Change to have the Table 1 field prior to the Table 2 field worked.

Thank you