SQL Statement Help 2

[dethfire]

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.

[jofa]

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