Hi,
I have two tables which are linked using inner join based on one commom field . The filter option is based on first table. The first table have two entries and the scond table have 5 entries . From second table out of 5 entries, i want to select 1 entry based on some constant value .
How to achieve this?