Anything wrong with this?

[dethfire]

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

[Aes]

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

[DaveMaxwell]

From what I understand, sub-selects are NOT available until v4.

[garymailer]

Dave is correct subselects are not supported ni v3.XX of MySql