SitePoint Sponsor

User Tag List

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

    SQL Statement Help 2

    Ok here is an easy one, but SQL seems hard for me to visual so maybe someone can help.

    I have two tables:

    tblCarrierPool
    - carrierpoolid
    - name

    tblClaim
    - carrierpoolid
    - claimid
    - datefiled
    - amount

    I have a name and I need to find the carrierpoolid to get the records of claimid, datefiled and amount from tblclaim.
    Last edited by dethfire; Jun 7, 2002 at 09:14.
    Free Science Homework Help
    http://www.physicsforums.com

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    select 
      claimid, datefiled, amount
    from
      tblclaim c inner join tblcarrierpool cp
      on c.carrierpoolid = cp.carrierpoolid
    where
      name = @yourvalue
    Looks like you need to read
    MSDN - Join fundamentals


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
  •