SELECT * FROM users WHERE client_id = 7 AND username LIKE '%a%'; user table: id (pk) client_id (pk and fk to client table) username
I just want a dumb sql like this! On Fri, Jan 16, 2009 at 11:19 AM, Andrus Adamchik <[email protected]>wrote: > > On Jan 16, 2009, at 3:14 PM, Sid Ferreira wrote: > >> >> Dude, of course I agree that the correct is to get the client and ask for >> it's users wich login is like the parameter I sent.But, if I can't simply >> select all users based on the parameter, it's pointless. >> I mean, I can't do any SQL I want, it's a limitation much more than >> helpfull. >> > > Dude, you are not doing a good job explaining what you are trying to do. So > we are shooting in the dark with our suggestions. > > Andrus > > -- Sidney G B Ferreira Desenvolvedor Web - Tibox Innovations
