Does anyone have a query that would provide the following information? Given a particular username what we need are the corresponding record(s) from the users table in particular the first name, last name and Blackboard ID/pkID.

Any help appreciated.

--------------------------------------------------

Gary Clay

Learning Development Manager

Learning Development and Innovation

Staffordshire University

Beaconside Campus

Stafford ST18 0AD

Telephone +44 (0) 1785 353648

e-mail [log in to unmask]

The information in this email is confidential and is intended solely for the addressee. Access to this email by anyone else is unauthorised.

If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, except for the purpose of delivery to the addressee, is prohibited and may be unlawful. Kindly notify the sender and delete the message and any attachment from your computer.