> I'm joining a few tables and grouping them by their "package".
> It works great until I try to add an ORDER BY price statement
> to the sql. When I do that, it creates several groups. The
> pricing order takes precedence over the grouping done in CF.
> How can I order by price and stay within th
Chris,
Try using an "Order By" in your SQL in the query after the WHERE
statement:
SELECT contractors.company_name as company, contractors.city,
bid_results.price, bid_results.project_id, bid_packages.label
as package
FROM bid_packages, contractors, bid_results
WHERE bid_pack
How about explicitly specifying all columns in the order by?
ORDER BY Package,price,Company,City,Project_id
HTH,
Steve
At 05:53 PM 6/20/2000 -0700, Chris Giminez wrote:
>I'm joining a few tables and grouping them by their "package". It works
>great until I try to add an ORDER BY price statem
3 matches
Mail list logo
