In SQL, How do you pull a table with multiple information from a particular database?

Question

I'm trying to pull customer information, like name, address, city, state, zip code, and daytime phone number from a database. Because everything I tried it has been denied.

Answer 1

Which SQL engine are you using: Access, ODBC, Oracle, MySQL?? This makes some difference, especially if you're getting you're indeed getting a "denied error"...

Usually, a normal SELECT statement will do the trick. However, if you're using an engine such as MySQL, don't forget to use the "USE db" statement to tell the engine which database you're using.

Answer 2

You did not specify which version, but this should cover 6.5, 7.0, 2000

When retrieving data from a SQL Server database, take full advantage of views when appropriate. This is especially true if you are not encapsulating your Transact-SQL in stored procedures as recommended. While calling a view is not usually as efficient as using a stored procedure to retrieve data, it is much more efficient that using dynamic Transact-SQL in your ASP code or COM components. [

Answer 3

You will probably get a bunch of answers on this one. A simple select command, i.e.,
select name, address, city, state, zipcode, phone
from database.table
should suffice. You will probably need to qualify it with a
where fieldname equal condition to filter out unneeded data.