Select Query

[Girish481]

There are 2 Tables, 1.Marks 2.Ctrl Marks Table have following Data : CtrlKey M1 M2 M3 M4 M5 M6 1 10 18 00 13 12 19 2 20 21 23 24 18 AB ... Ctrl Table Have following Data : CtrlKey Rollno 1 11 1 12 1 13 1 14 1 15 1 16 2 17 2 18 2 19 2 20 2 21 2 22 ... there is a new ctrlkey on every 6 rollnos I want Output Should like this : Rollno Marks (like Foreign Key) 11 10 12 18 13 00 14 13 15 12 16 19 17 20 18 21 ... Please help me to write a single select query to get output. Girish Kumar Sharma

[jijoaresseriljose]

hi, i dont understand the relation between Marks and Ctrl tables. regards Jijo

jijo jose

[Girish481]

Both the table (Marks and Ctrl) have a common field "ctrlkey" and have relation between them. Please re-think upon it and do needful as early possible.

[Krish KP]

this cannot be done using a simple SELECT query. 1. Create a cursor for "Marks" table 2. create a cursor for "Ctrl" table which fetches corresponding data for hte ctrlkey fetched by outer cursor 3. in the inner look you can arrange the data as you required

Regards KP