SQL Query in a Query?

[MichaelRSnow]

I’m new SQL, trying to teach myself but need some help

--PREVIOUS Product ID

, ISNULL(CONVERT(char, ReplacedProductID), '') AS 'Previous Product ID'

I have this code (above) thatreturns a Product ID number, can I run a query off this result (within the samequery) to return another value linked to that ID within the database i.e.



I have this code (below) whichreturns a value for ‘Current Product ID’, which I would like to re-run withinthe same query on the result of the ReplacedProductID to return the Rate % forthis replaced ID?

-- RATE

       , ISNULL(CONVERT(char, RatePercentage), '') AS 'Rate'

Can yourun a SQL Query on a result within a SQL query?

 

[Joe4]

You can do that, using Subqueries.
See: https://community.modeanalytics.com/sql/tutorial/sql-subqueries/

 

[MichaelRSnow]

Thanks i'll look into that