Viewing 2 posts - 1 through 2 (of 2 total)
Hi ,
Is it possible to pass parameters to the report ?
October 9, 2012 at 1:19 am
#1547037
Try the following statement :
select * from Customer left join
(select distinct CustId,SIC from CustInfo a
where SIC=(select max(SIC) from CustInfo
where a.CustId=CustId)
  as CustInfoSelection
on Customer.CustId=CustInfoSelection.CustId
October 28, 2004 at 3:28 am
#528271