arranging in particular order

  • Thread starter Thread starter cliff
  • Start date Start date
C

cliff

Hi, mydata table is

sr nos (int+mod)
1 14 5
1 18 9
2 23 5
2 29 11
3 16 7
3 25 7

transa table is
(int+mod) ns
1 1
2 1
3 1
4 2
5 2
6 2
7 3
8 3
9 3
10 4
11 4
12 4
13 4

I want arrange/display nos in mydatatable in according to ns in transtable
like
nos
14
23
16
25
18
29

how to write to query to solve the problem

thanks million

cliff
 
Back
Top