Produce output based on values in table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • prachi123
    New Member
    • Apr 2013
    • 1
    #1

    Produce output based on values in table

    i have a table like as below; as table name temp

    Code:
    SR	ER	x	Y	z
1	1	P	Q	R
2	5	l	M	N
6	9	S	T	G
10	10	Y	O	P
    I am looking a output as below :-

    Code:
    MRP	x	Y	z
1	P	Q	R
2	l	M	N
3	l	M	N
4	l	M	N
5	l	M	N
6	S	T	G
7	S	T	G
8	S	T	G
9	S	T	G
10	Y	O	P
    Last edited by acoder; Apr 19 '13, 12:19 PM. Reason: [code] tags for better formatting
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      Join it to a table that contains a sequential number field on your start and end range.

        Comment

        • Naveeds
          New Member
          • Apr 2013
          • 2
          #3
          make a new with joins

            Comment

            Previous template Next
            Working...