Skip to Content
0
Apr 21, 2010 at 04:55 PM

After Inner join, again filter data with constant value

277 Views

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?