Where clause

Yashwanth_ — Wed, 12 May 2021 10:43:44 GMT

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.

Re: Where clause

PapaJapa — Wed, 12 May 2021 13:31:22 GMT

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 ';