I'll try this combination suggestion I think this sounds what I've searched for as as an alternative to UNION. Thanks for the quick response.
can you run the two queries individually, combine them into one list, and return that? i guess thats relatively inefficient
if i've followed all the bits correctly - you're right, doesn't seem to be a UNION with the ORM
so you essentially need to figure out how to get the result into an SS_List
is product report from silvershop?
I would like to expand the product report, because we have a customized backend-shop in addition to the normal silver shop. Therefore I would like to create a report that shows the number of ordered products of both shops. Until now I could not figure out how to get the wished result with the ORM. So I decided to do it with SQL, which already gives the wished result when I run it in phpmyadmin.
you could probably do a raw SQL query with union but if there's an ORM-y way to get the same data i'd tend towards it
what exactly are you trying to achieve?
Or is there a possibility to use a raw SQL Statement with the same output?