September 14, 2005 at 12:24 am
I have two table
1> Master
2 > Detail
fields are
Master : - code,Name , elcl _grant ,ol_grant
Detail : code, elcl, ol
e.g.
data code Name elcl_grant Ol_Grant master : 1>1001 Shantaram 10 20
2> 1002 Deepak 10 20
Detail :
code elcl ol
1001 2 0
1002 1 1
1002 3 0
I want following result
Name Elcl Grant OL _Grant Elcl_given Ol Given Shantaram 10 20 2 0
Deepak 10 20 4 1
Waiting for your valuable suggestion
September 14, 2005 at 1:08 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply