From 94279e4e101cc64c6c2de9008ac95029b4aca00f Mon Sep 17 00:00:00 2001
From: Roland Haeder <roland@mxchange.org>
Date: Wed, 14 Oct 2015 14:44:08 +0200
Subject: [PATCH] =?utf8?q?join=20users=20in=20to=20have=20users=20be=20abl?=
=?utf8?q?e=20to=20register=20even=20when=20their=20email=20address=20is?=
=?utf8?q?=20already=20added=20Signed-off-by:Roland=20H=C3=A4der=20<roland?=
=?utf8?q?@mxchange.org>?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit
---
src/org/mxchange/jusercore/model/user/LoginUser.java | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/org/mxchange/jusercore/model/user/LoginUser.java b/src/org/mxchange/jusercore/model/user/LoginUser.java
index c6162dc..3f89337 100644
--- a/src/org/mxchange/jusercore/model/user/LoginUser.java
+++ b/src/org/mxchange/jusercore/model/user/LoginUser.java
@@ -63,7 +63,7 @@ import org.mxchange.jusercore.model.user.status.UserAccountStatus;
@NamedQueries (
{
@NamedQuery (name = "AllUserNames", query = "SELECT DISTINCT u.userName FROM users AS u ORDER BY u.userId ASC"),
- @NamedQuery (name = "AllEmailAddresses", query = "SELECT DISTINCT c.contactEmailAddress FROM contacts AS c ORDER BY c.contactId ASC"),
+ @NamedQuery (name = "AllEmailAddresses", query = "SELECT DISTINCT c.contactEmailAddress FROM contacts AS c INNER JOIN users AS u ON u.userContact = c ORDER BY c.contactId ASC"),
@NamedQuery (name = "SearchUserName", query = "SELECT u FROM users AS u WHERE LOWER(u.userName) LIKE LOWER(:param)"),
@NamedQuery (name = "SearchEmailAddress", query = "SELECT u FROM users AS u INNER JOIN contacts AS c ON u.userContact = c WHERE LOWER(c.contactEmailAddress) LIKE LOWER(:param)"),
@NamedQuery (name = "AllPublicUsers", query = "SELECT u FROM users AS u WHERE u.userAccountStatus = :CONFIRMED AND u.userPublicProfile = TRUE")
--
2.39.5