From 0414d79d9345b5ce828292bdf87ad7772dbe1226 Mon Sep 17 00:00:00 2001
From: nfreear <nfreear>
Date: Tue, 23 Jan 2007 19:11:40 +0000
Subject: [PATCH] Fixes bug MDL-8234, "New groups code & AS keyword" - fixed
 typo in last commit.

---
 group/db/dbbasicgrouplib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/group/db/dbbasicgrouplib.php b/group/db/dbbasicgrouplib.php
index 5bfade450d..87a6b44d86 100644
--- a/group/db/dbbasicgrouplib.php
+++ b/group/db/dbbasicgrouplib.php
@@ -152,7 +152,7 @@ function groups_db_get_group_settings($groupid, $courseid=false, $alldata=false)
 function groups_db_users_in_common_group($userid1, $userid2) {
 	global $CFG;
     $havecommongroup = false;
-	$sql = "SELECT gm1.groupid, 1 FROM {$CFG->prefix}groups_membersgm1 " .
+	$sql = "SELECT gm1.groupid, 1 FROM {$CFG->prefix}groups_members gm1 " .
 			"INNER JOIN {$CFG->prefix}groups_members gm2 " .
 			"ON gm1.groupid = gm2.groupid" .
 			"WHERE gm1.userid = '$userid1' AND gm2.userid = '$userid2'";
-- 
2.39.5