SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    does not play well with others frezno's Avatar
    Join Date
    Jan 2003
    Location
    Munich, Germany
    Posts
    1,391
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Multi Table Query

    I don't get a query over multiple tables to work.
    it's driving me nuts...

    Since i think it's too much to post the (relevant) table structures + test data here, is there any way to provide you guys with that data or shall i post it here nontheless?
    We are the Borg. Resistance is futile. Prepare to be assimilated.
    I'm Pentium of Borg.Division is futile.Prepare to be approximated.

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    You could start by posting your query, and explain what you want to achieve.
    Then, if necessary, you can post the table definitions and test data.

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,275
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    just post the query and the error message
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    does not play well with others frezno's Avatar
    Join Date
    Jan 2003
    Location
    Munich, Germany
    Posts
    1,391
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by guido2004 View Post
    You could start by posting your query, and explain what you want to achieve.
    good point

    ok, problem solved

    when writing down everything here and going through the data again trying to make it understandable, i realized that there was a missing entry in my table.
    Well, as good ol' Konfuzius already said: If data missing you cannot see.

    heck, what a shame

    ie, my query does work if correct/all data is provided
    and now, frez,
    We are the Borg. Resistance is futile. Prepare to be assimilated.
    I'm Pentium of Borg.Division is futile.Prepare to be approximated.

  5. #5
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by frezno View Post
    when writing down everything here and going through the data again trying to make it understandable, i realized that there was a missing entry in my table.
    Damn, we're good!


Bookmarks

Posting Permissions

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