Results 1 to 11 of 11

Thread: self join help

  1. #1
    Join Date
    Jan 2007
    Posts
    6

    Unanswered: asfd adf asfaffda

    fda a afafsfdsfdas fasfasfdasfdfdfsfd
    Last edited by gesar; 01-09-07 at 20:03.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    use two alias names for the table.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by gesar
    i want to make a self join query on the table below
    why?

    i mean, for what purpose? what is the self-join supposed to tell you? what column(s) will the join be on?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jan 2007
    Posts
    6

    self join

    asfda a fdasfasf asd fasfd asfafadf
    Last edited by gesar; 01-09-07 at 19:54.

  5. #5
    Join Date
    Jan 2007
    Posts
    6
    y asdf a fasf asfd asfdasfdasfasfdasfdasf d
    Last edited by gesar; 01-09-07 at 19:55.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what is the self-join supposed to do for you?

    is this some type of homework assignment?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jan 2007
    Posts
    6
    afd asfd asfsfasfdafdsfdsfddf
    Last edited by gesar; 01-09-07 at 19:55.

  8. #8
    Join Date
    Jan 2007
    Posts
    6
    a fs fafdasfddfdfsfa
    Last edited by gesar; 01-09-07 at 19:55.

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    let me make two comments

    first, about your assignment -- if you do not know what the self-join should do for you, then you are going to have trouble with sql forever, and maybe you should take up carpentry or something else instead

    second, about your self-join -- it is correct, although not very useful

    good luck
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Jan 2007
    Posts
    6
    afd as fasfdasfdasfdasfdasfdaf
    Last edited by gesar; 01-09-07 at 19:55.

  11. #11
    Join Date
    Mar 2004
    Posts
    480
    your question was not clear at all. You are also not supposed to post any homework questions on this (or other forums) and pose them as something else.

    You should also note that you don't just do a self join on a table for no reason at all, there should be a reason behind it and you did not describe that at all, even when asked.

    going forward it would help if you asked your questions in a clearer manner, then you will likely get the help you need rather than little or none at all.

    Just two cents worth from someone who has been around the block a few times.

Posting Permissions

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