Hello Gary SELECT BATCH_UID, PK1, firstname, lastname FROM bb_bb60.users WHERE user_id ='username'; You could do the following to see what other fields may be of interest DESC bb_bb60.users; Thanks, Jake -------------------------------------------- Jake Gannon [log in to unmask]<mailto:[log in to unmask]> Computing Services The University of Liverpool External: 0151 794 4458 Internal: 44458 -------------------------------------------- From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of CLAY Gary M Sent: 12 January 2010 11:56 To: [log in to unmask] Subject: Blackboard database query needed 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]<mailto:[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.