Join 2 qureries

[Jafrywilson]

How to join these queries without union all

select f.mobid, f.merchant, f.price
from (
   select mobid, min(price) as minprice
   from tbl_merchant group by mobid 
) as x inner join tbl_merchant as f on f.mobid = x.mobid and f.price = x.minprice order by mobid

select f.mobid, f.merchant, f.price
from (
   select mobid, max(price) as minprice
   from tbl_merchant group by mobid
) as x inner join tbl_merchant as f on f.mobid = x.mobid and f.price = x.minprice order by mobid

Urgent help me!
Tnx in advance

[NeoPa]

How about you ask the question a little more meaningfully than how does one join these queries. What do you actually want? What manner of join are you looking for?

[Jafrywilson]

I need to connect these two queries into a single one

[NeoPa]

Right axis. Wrong direction.

It needs to be more clear rather than less.

[ck9663]

If you're trying to merge these two queries into one result set with both result set below the other, you're going to need UNION ALL. If you need to return as one result set with one on right of the other, you're going to need to do a JOIN. Which one are you trying to do?

Happy Coding!!!

~~ CK