SQL Power Software Forum

select t1.*,t2.Product_Name from
(
select mobid,
max(case when seq=1 then merchant else null end) as min_merchant,
max(case when seq=1 then price else null end) as min_price,
max(case when bseq=1 then merchant else null end) as max_merchant,
max(case when bseq=1 then price else null end) as max_price
from
(
select row_number() over (partition by mobid order by price) as seq,row_number() over (partition by mobid order by price desc) as bseq,mobid, merchant,price
from tbl_merchant

t
where (seq=1 or bseq=1) and mobid in(select MOBID from tbl_product where Client_Name='wilson')

group by mobid

as t1 INNER JOIN tbl_product as t2 on t2.mobid=t1.mobid

In the above query i need to add my_Price field where
my_price is where my name matches for that product