Query - IN

From: Chronos (Kronos_..mx.net)
Date: Mon Jan 16 2006 - 05:03:28 EST

  • Next message: Joshua Pyle: "Re: Query - IN"

    Hi!

    We use MySQL 4, is there a simple solution to make this query in cayenne?
    What I want is at last this: a GroupObject with w = Max(w), r=Max(r) and
    so on.

    PHP:
    "SELECT Max(w) AS w, Max(r) AS r, Max(e) AS e, Max(d) as d FROM
    $grouptable WHERE id IN (".sql2in("SELECT group_id FROM $user2grouptable
    WHERE user_id=$userid").")"

    Gr
    pk

    This archive was generated by hypermail 2.0.0 : Mon Jan 16 2006 - 05:03:29 EST