Help need for loading data

[#1]

I am loading Table A(PO_Key is combination of 3 fields).

From table B and C i want to load only those PO_Keys which are present in table A.

Pl help..

Table A:

AL1,

AL2,

AL3,

AL1 &'-'& AL2 &'-'& AL3 as PO_Key,

Reg,

Date,

Mastr

From Qvd A(qvd)

where Year(Date)>'2007' ;

Table B:

BL1,

BL2,

BL3,

BL1 &'-'& BL2 &'-'& BL3 as PO_Key,

Meg,

str

From Qvd B(qvd) ;

Concatinate

CL1,

CL2,

CL3,

CL1 &'-'& CL2 &'-'& CL3 as PO_Key,

Ver

From Qvd C(qvd);

[MayilVahanan]

hi

try with exists concept. like

where exists(po_key,po_key);

[#3]

I tried this.. It is saying PO_Key does not exsist.

This may br PO_Key is combination of 3 fields.

[MayilVahanan]

hi

try  with resident concept and drop the actual table.

like

load * resident tablename where exists(fieldname,fieldname);

hope it helps.