SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard dethfire's Avatar
    Join Date
    Aug 2000
    Posts
    2,477
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Anything wrong with this?

    SELECT p.ItemNumber, ci.ClaimItemTotal, cl.CheckAmount, cl.CreditAmount, cl.AdjustmentAmount, cl.AdjReasonCode
    FROM tblClaimItem ci CROSS JOIN
    tblClaim cl INNER JOIN
    tblProduct p ON ci.ProductId = p.ProductId
    WHERE (ci.ClaimId IN
    (SELECT claimid
    FROM tblclaim
    WHERE ClaimNumber = '16851-011'))
    ORDER BY ci.ClaimId
    Free Science Homework Help
    http://www.physicsforums.com

  2. #2
    SitePoint Wizard Aes's Avatar
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    3,392
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try it, although I haven't had much luck with queries utilizing sub-SELECTs in my experience. I don't even know if it's supported in MySQL 3.23.49.

    -Colin
    Colin Anderson
    Ambition is a poor excuse for those without
    sense enough to be lazy.

  3. #3
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,267
    Mentioned
    116 Post(s)
    Tagged
    1 Thread(s)
    From what I understand, sub-selects are NOT available until v4.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  4. #4
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Location
    London
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dave is correct subselects are not supported ni v3.XX of MySql


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
  •