Results 1 to 3 of 3
Thread: SQL statement help!
Jun 5, 2002, 08:47 #1
SQL statement help!
i am so bad with figuring out how to use different statements to get what I want, maybe you can help.
Here are my tables and what they contain:
Whats my statement look like? Using my WL_Claim to find my claimID to find my productID to find my description?
adding to the complexity, not only do I need the description data, but I need to go back and display other data (which I didn't include) from the tblCLaimItem.
Last edited by dethfire; Jun 5, 2002 at 08:53.Free Science Homework Help
Jun 5, 2002, 12:49 #2
- Join Date
- Mar 2002
- 0 Post(s)
- 0 Thread(s)
You mean like this?
select ci.claimid, ci.productid, ci.othercolumn, p.description
from tblclaimitem ci inner join tblproducts p
on ci.productid = p.productid
where ci.claimid in
where wl_claim like @yourvalue)
order by ci.claimid
Jun 5, 2002, 13:50 #3
yes, it worked perfectly, thank you so much, SQL is hard for me
Last edited by dethfire; Jun 6, 2002 at 10:51.Free Science Homework Help