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?