joins

[vignesh_s]

i have a table1 ,i want Max(NAV_ID) such that,say i have Date=1/11/12 Fundid=99,NAV_ID=2 and Date=1/11//12 fundid=99,NAV_ID=3

,i want to diaplay only the NAV_ID=3,Date=1/11//12 fundid=99 followe by other fields(A,B,C,D....) w.r.t to NAV_ID

i tried load resident to achive ths and i left joined with load table ,i did not got the result properly

table1:

load

Date, FundID,  NAV_ID,A,B,C,D,E,F;

[Anonymous]

try

Load Date, FundID,  A,B,C,D,E,F

max(NAV_ID)

group by Date, FundID,  A,B,C,D,E,F

[Anil_Babu_Samineni]

I don't think where Max() won't work direct load. You could use something like Left / Right join to deserve

Table1:

Load Date, FundID,  A,B,C,D,E,F From Table1;

Right Join (Table1)

Load Date, max(NAV_ID) Resident Table1 group by Date;

[Anonymous]

absolutely right your solution

[vignesh_s]

i used right join but ,whn i compare the result with xsl file the value is wrong

[d_prashanthredd]

Hi Vignesh,

What you compared and what is wrong in that?

Anil's solution gonna work fine and the sollution was to identify the max NAV_ID.

If you can specify the problem clearly, anyone can provide you the correct solution.

[vignesh_s]

tanks i got solution

[Anil_Babu_Samineni]

You need to understand the Decimal concept using Num()..