Hi, I have feeling it has been discussed already in the past, but I
can not find the answer in the list archive.
I would like to query the database something like this:
select sum(quantity) as qty, product_name, sum(quantity) * price *
(1+tax_rate/100)
FROM `prestashop`.`ps_view_new_order_detail`
where id_order = 1
group by product_name
I think it is not possible to create similar kind of queries through
the SQLObject.
(http://www.sqlobject.org/FAQ.html#what-about-group-by-union-etc)
Is there a way to drop this "handcrafted" query to the SQLObject and
get the result?
Regards
Petr
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
