How do I to use INNER JOIN in Browse Dialog Component?

Example I have a table named Order and it has a field ClientId, but I need to seek by field ClientesName that not is in table Order.

So I need to use SQL INNER JOIN or LEFT JOIN to fill the Browse Dialog Component.

How do I do this?

at,

Marcio Valerio da Silva

at,

Marcio Valerio da Silva

Hi Marcio,

The easy way is to create a view in SQL, then create a BO using that view and assign that BO to the Browser Dialog. 

There are couple of messages in the forums about the same issue.  Search for Browse Dialog in the forums.

Edhy Rijo