locked
SQL Query RRS feed

  • Question

  • User-1129594362 posted

    Here is My Table

    R1 A1                B2                             StatusId
    1 100                  100001                       1
    2 1122334455678            100001                       1
    1 100               100002                             2
    1 100                   10045                          1
    2 1122334455678             1000046                      2


    My UserID is 10001 

    A1 is My FriendID  A1 has requested the B2

    Now I want to get My Request From the column B2 and Also Id who has accepted the request based on the status column

    1 - pending

    2 - accepted

    I want O/P like as follows

    R1	A1		           B2	          			
    1	100,100002	       100001					
    


    Monday, March 25, 2013 2:17 PM

Answers

  • User-1716253493 posted

    Use repeater/listview inside gridview intead creating sql query

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 25, 2013 9:35 PM

All replies

  • User595841651 posted

    why are you trying to combine the values into one field for output instead of getting the list?

    Monday, March 25, 2013 3:42 PM
  • User-1716253493 posted

    Use repeater/listview inside gridview intead creating sql query

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 25, 2013 9:35 PM