Make sure you click on "Run As Script"

Ooops, sorry about that.

SELECT    Email  FROM  {objectQualifier}Users INNER JOIN
                      {objectQualifier}UserPortals ON Users.UserID = UserPortals.UserId
WHERE     (UserPortals.PortalId = 0)

Man, I know I am being a pain in the rear, but that is also not working.

Here is what I get:

System.Data.SqlClient.SqlException: The column prefix 'UserPortals' does not match with a table name or alias name used in the query. The column prefix 'Users' does not match with a table name or alias name used in the query. The column prefix 'UserPortals' does not match with a table name or alias name used in the query. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) SELECT Email FROM dotnetnuke_Users INNER JOIN dotnetnuke_UserPortals ON Users.UserID = UserPortals.UserId WHERE (UserPortals.PortalId = 0)