Where Exists Renamed Field

[hvfalcao]

Hi,

I'm trying to use where exists in some load script:

Pedido:

LOAD

IDPEDIDO,

IDPESSOA  // this IDPESSOA is the client ID.

IDREVENDEDOR; // this IDREVENDEDOR is the dealer ID.

SQL SELECT

IDPEDIDO,

IDPESSOA,

IDREVENDEDOR

FROM PEDIDO;

Revendedor:

LOAD

IDPESSOA AS IDREVENDEDOR,

NMPESSOA AS NMREVENDEDOR,

WHERE EXISTS (IDREVENDEDOR) 

// Here is the problem: If I choose "WHERE EXISTS (IDPESSOA)" it'll filter by IDPESSOA from table Pedido (that's not what I want, because it will load only the clients IDs. I need to filter all IDREVENDEDOR from table Pedido, witch will bring me only the dealers ID's.

SQL SELECT

IDPESSOA,

NMPESSOA

FROM PESSOA;

So... There is any way to apply Where Exists with renamed fields?

Thank You!

[sunny_talwar · Accepted solution]

Try this may be:

Pedido:

LOAD

IDPEDIDO,

IDPESSOA  // this IDPESSOA is the client ID.

IDREVENDEDOR; // this IDREVENDEDOR is the dealer ID.

SQL SELECT

IDPEDIDO,

IDPESSOA,

IDREVENDEDOR

FROM PEDIDO;

Revendedor:

LOAD

IDPESSOA AS IDREVENDEDOR,

NMPESSOA AS NMREVENDEDOR,

WHERE EXISTS (IDREVENDEDOR, IDPESSOA)

SQL SELECT

IDPESSOA,

NMPESSOA

FROM PESSOA;

[hvfalcao]

Sunny,

It works! Thank you!