Thanks. My actual schema is more complicated, the equivalent of the list_user table is then referenced in other tables rather than using both list and user.
-Brendan On Mar 17, 1:27 pm, Richtermeister <[email protected]> wrote: > Try this: > > $c = Criteria; > $c -> addJoin(UserPeer::ID, ListUserPeer::USER_ID, > Criteria::LEFT_JOIN); > $c -> add(ListUserPeer::USER_ID, null, Criteria::ISNULL); > > that should work. > Also, you don't need an id column in the list_user table, in fact it > interferes with symfony on some levels. > Just set both user_id and list_id to primaryKey: true and drop the id > column. > > Hope this helps, > Daniel > > On Mar 17, 9:29 am, "[email protected]" <[email protected]> wrote: > > > Sorry if this question is a little basic. > > > I'm trying to create a Criteria to retrieve records from a table that > > aren't in another table as a foreign key. > > > User: > > id: ~ > > name: varchar(255) > > > ListUser: > > id: ~ > > user_id: ~ > > list_id: ~ > > > Trying to retrieve records from User that aren't in ListUser. Is > > there an easy way to do this with Criteria? > > > Thanks, > > > -Brendan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
