Where clause

[Yashwanth_]

Hi, 

i have 2 tables like 

Table1:

Load 

id, name, region, state, sales 

from *** .qvd;

Table2:

Load 

custid, custname, orderid, orderstatus 

from ***.qvd;

I want to have a where condition from both the tables for example i want region from table 1 and orderstatus from table2.

Like where region = '  XXX ' and orderstatus = 'XXX '.

Can anyone help me with this.

Thanks Yashwanth.

[PapaJapa]

Hi. You can use where condition in two tables. 

Table1:

Load 

id, name, region, state, sales 

from *** .qvd

where region = '  XXX ' ;

Table2:

Load 

custid, custname, orderid, orderstatus 

from ***.qvd

where orderstatus = 'XXX ';