All fields from table showing up in query

[nickperez22]

I was developing some queries on a database that I didn't design. For some reason, even though I select only a couple of the fields from the tables for the query all the fields from the selected tables show up when I ran the query. Why is this happening and what can I do to correct it?

 

[tlbroadbent]

Open the query in SQL view and check to see if an asterisk (*) is in the select list. Sometimes, an * will show in the SQL View that doesn't appear in the designer grid. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.