Selecting multipe fields from Enterprise Manager SQL

I have  a query with some joins and I only want to select ALL fields from one of the tables in my 'select' statement, if I do:

Select * from ... bla bla it will include all the fields from all tables, the alternative is to type the name of each field and there are like 40 fields in the table, is there a way to quickly select the names of all fields in that one table ?

I am using SQL 2008 Enterprise Manager.
LVL 1
AleksAsked:
Who is Participating?
 
LIONKINGCommented:
Do

SELECT yourTable.*
FROM ....
0
 
AleksAuthor Commented:
thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.