⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

query function

Started by Tim, 18 May 2012 - 12:01 PM


visioncoding

visioncoding
  • profile picture
  • Member

Posted 18 May 2012 - 12:01 PM

Hi everyone! i have a question about sql query
i know that there is no query function in grocery but i have some sql statement that i could not converted it to grocery function
Does anyone can help me about this?

sql



select * from (select group_id from t_super_user_group where user_id=100) as table1
left join (SELECT * FROM t_user_group left join t_user on t_user_group.user_id=t_user.id) as table2 on table1.group_id=table2.group_id


thank you in advanced ;)
Tim