Performing query based on another query's result First I have to run the query (1) using the pagedetailid number to get the adblockid. Then I have to put that adblockid into the other query (2) to get the result. What I would prefer is a single query. 


select distinct Flyerid, adblockid, OriginalPagedetailid, Pagedetailid, 
category, brand, [Sales Price], Size, Format, manufacturer
from prdcnen where pagedetailid = '67197228466'

select distinct Flyerid, adblockid, OriginalPagedetailid, Pagedetailid, 
category, brand,[Sales Price], Size, Format, manufacturer
from prdcnen where Adblockid = 1521368536511158



How can I merge these two statements?
One possible way is an inner self join.

SELECT DISTINCT
       p1.Flyerid,
       p1.adblockid,
       p1.OriginalPagedetailid,
       p1.Pagedetailid,
       p1.category,
       p1.brand,
       p1.[Sales Price],
       p1.Size,
       p1.Format,
       p1.manufacturer
       FROM prdcnen p1
            INNER JOIN prdcnen p2
                       ON p2.Adblockid = p1.Adblockid
       WHERE p2.pagedetailid = '67197228466';