vizaik

 Profile Answers by vizaik 

• Nov 13th, 2007

 

Yes, sql override in lookup used to lookup more than one value from more than one table.

chandrarekha

 Profile Answers by chandrarekha 

• Nov 28th, 2007

 

You can join  the data from multiple tables in the same database by using lookup override

You can use sql override if

1. To use more than one look up in the mapping
2. You can use SQL override for filtering records in the cache to remove unwanted data

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

 

Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..

avneeshrathor

 Profile Answers by avneeshrathor 

• Nov 3rd, 2009

 

For some special cases like for example, You need to select the max salary
from emp table for a particular dept. then use

"select max(salary) from emp where deptno=in_dept_no
group by deptno".

Kindly let me know if this is possible without using SQL override in lookup.