Hai
It is my drupal chat code for display buddy list
$result = $database
->select('drupalchat_users', 'n')
->fields('n', ['uid', 'name', 'status', 'session'])
->condition('uid', $user->id(), '<>')
->condition('timestamp', (time() - \Drupal::config('drupalchat.settings')->get('drupalchat_user_latency')), '>=')
->execute()
->fetchAll();
I want to update this query Using inner join
$result = db_query('SELECT n.uid,n.name,n.status,n.session FROM drupalchat_users n INNER JOIN group_content_field_data g ON n.uid = g.entity_id');
So help me to Add this inner join in above added query??
Comments
Comment #2
hiramanpatilYou might get answer here - https://www.zyxware.com/articles/5093/drupal-7-how-to-join-multiple-database-tables-using-db-select
Thanks,
Comment #3
rahulmon johnson