Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014

    Red face Unanswered: how make db for refrence in sql

    hi there
    i am making a project where i have to add city,agentname,rankofagent,refrenceagentname
    the problem is that who can i make a table where suppose i add member a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p
    like that b is joined by a
    c is joined by b
    d by c, e by d and so on,
    what i want here is that how can i get the result suppose i want to see that chain of p.
    i want result to be printed as a,b,c,d,e,f,g,h,i,j,k,l,m,n,o
    either result should be in horizontal form or vertical. with or withought comma.
    kindly help me to design and implement the query.
    i am doing this in SQL

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Don't do this in the SQL - do it in your presentation layer.
    Home | Blog

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    Sorry, but I can't understand your requirements from what you wrote.

    ACTUAL sample data, please, and ACTUAL sample output.

    (ACTUAL table structure DDL would be nice too...)
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts