On 10/6/05 4:13 AM, Uwe Voelker wrote: >> But is there a way to do the following in RDBO: >> >> SELECT DISTINCT products.* >> FROM products LEFT JOIN prices ON (products.id = prices.product_id) >> WHERE prices.region = 'DE' >> LIMIT 1, 1 >> >> RDBO has no problems with the FROM and WHERE line, but I don't know how >> to achieve the SELECT and LIMIT. > > (The limit bug is fixed.) > > I think other ERM call this "auto-join" (CDBI::Sweet?). Maybe you can > call it "search_objects", because it does a selection (WHERE) but no > projection (SELECT *) on these tables. > > Do you understand my concern? Do you think you can make this into RDBO?
I guess I'm wondering why require_objects isn't sufficient. IOW, is the DISTINCT part important or is it the fact that only columns from products are actually fetched? -John ------------------------------------------------------- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
