Bettina

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.

andante

can you run the two queries individually, combine them into one list, and return that? i guess thats relatively inefficient

andante

if i've followed all the bits correctly - you're right, doesn't seem to be a UNION with the ORM

andante

so you essentially need to figure out how to get the result into an SS_List

Bettina

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.

andante

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

Bettina

Or is there a possibility to use a raw SQL Statement with the same output?