Subject | problem with grouping |
---|---|
Author | Michal Žeravík |
Post date | 2006-02-24T09:48:39Z |
hi all,
have tables
user
--> demand (key userid)
--> offer (key userid, demandid)
Every offer has price.
I need to select only best offers (grouped by userid) to a demand.
Because I must group by all selected rows in FB,
I cannot use GROUP BY, because I need to select offers' price as well.
Any ideas?
Michalz
have tables
user
--> demand (key userid)
--> offer (key userid, demandid)
Every offer has price.
I need to select only best offers (grouped by userid) to a demand.
Because I must group by all selected rows in FB,
I cannot use GROUP BY, because I need to select offers' price as well.
Any ideas?
Michalz