Too late for me to respond. Sergey gave you the answer there.

>
>Cheers :)
>
>How can I do:
>
>declare @CategoryPrice smallmoney
>select @CategoryPrice = select Price from PriceInfo where CreditCategory = @PassedCategory
>
>

>select 'CT' as State, @CategoryPrice as Price, CreditType, county,
>registry, city, address, def1FName, Def1LName
>from CTCredit..CreditInfo where CredID in
>(select CredID from CartDetail
>inner Join CartContent on
>CartDetail.CartContentID = CartContent.CartContentID
>and CartContent.State = 'CT' and CartContent.CreditCategory = @PassedCategory )

>
>Is it right?