User Profile

Jafrywilson

Last Activity: Feb 19 '14, 09:45 AM

Joined: Aug 24 '10

Location:

Jafrywilson replied to Join 2 qureries

in SQL Server

Aug 24 '10, 01:21 PM
I need to connect these two queries into a single one

See more | Go to post
Leave a comment:

Jafrywilson started a topic Join 2 qureries

in SQL Server

Aug 24 '10, 10:10 AM

Join 2 qureries

How to join these queries without union all

Code:

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

Code:

select f.mobid, f.merchant, f.price

...

See more | Go to post

Last edited by NeoPa; Aug 24 '10, 12:20 PM. Reason: Almost all our rules broken here.

No activity results to display

Profile Sidebar

Leave a comment:

Join 2 qureries