select pkrreview.DK_Nu mber,pkrreview. BindingType,pkr review.Category ,pkcustomerorde r.CONo
from
(select distinct p.category 'Category',t.bi ndingtype 'BindingType',p .dknumber 'DK_Number',
p.AddDate 'ReviewDate',t. title 'Title',t.title id 'TitleId',cq.qu antityOrdered 'QtyOrdered',
cq.customerOrde rNO 'OrderNo',cq.cu stomerOrderDate 'OrderDate',cq. CODKdate,cq.Inv oiceNo,
co.billtoid 'BilledId' from title...