i think the developer is asking something different than an SQL Select statement, if he has access to the database already, he can easily create a select statement as:
SELECT * FROM tableName
I'm a little confused actually in regards to what he does want. you say he has access to the database already, with that access he should be able to examine the tables in the database, and create any SQL queries he needs.
are you using the eCommerce database?
ecommerce-database/
there is a screen shot on that page that shows the relationship diagram, is that what he wants?