How to issue a select statement for multiple assertion attribute.

Products

• SITEMINDER

Issue/Introduction

How is the select statement issued when configuring multiple assertion attributes in the Partnership Federation?
Are they issued as single select statement or separated statement?

When issued as a single select statement:
SELECT LastName,FirstName,EmailAddress FROM SmUser WHERE Name = 'mikel'

When issued as a separate select statement:
SELECT LastName FROM SmUser WHERE Name = 'mikel'
SELECT FirstName FROM SmUser WHERE Name = 'mikel'
SELECT EmailAddress FROM SmUser WHERE Name = 'mikel'

Environment

Release : 12.8

Component :SQL Based User Store

Resolution

Issue/Introduction:- * 
It is issued a separate select statement:

SELECT LastName FROM SmUser WHERE Name = 'mikel'
SELECT FirstName FROM SmUser WHERE Name = 'mikel'
SELECT EmailAddress FROM SmUser WHERE Name = 'mikel'