load with filter from another table

[#1]

Hi All!

I really appreciate your help with the following issue:_

I have 3 tables:

"Country_ID" (table name):

load

Phy_id,

Country

select * from Countries;

Activity:

load

Activites_phy_id,

Date,

Name;

select * from Activites;

Station:

load,

Station_phy_id,

Date,

Location;

select * from stations;

I need to load from Activity table and Station table only the phy_id that appears on country_id.phy_id.

I tried to do that with "where Exists(Phy_id, Activites_phy_id)" for example in the "Activity" table load but it didn't work. Can someone please advise?

Thanks!

[sunny_talwar]

May be use the Where Exists statement here:

"Country_ID" (table name):

load

Phy_id,

Country;

select * from Countries;

Activity:

load

Activites_phy_id,

Date,

Name

Where Exists(Phy_id, Activites_phy_id);

select * from Activites;

Station:

load,

Station_phy_id,

Date,

Location

Where Exists(Phy_id, Station_phy_id);

select * from stations;

[#3]

Thanks for you response! but it didn't work I received the following error

"Script line Error

Else"

[sunny_talwar]

Would you be able to share the logfile?