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

Rahul Johnson created an issue. See original summary.

hiramanpatil’s picture

rahulmon johnson’s picture

Status: Active » Closed (outdated)