Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hgalindo
Starting Member
2 Posts |
 Posted - 2008-04-16 : 11:34:00
|
I am new to SQL and have an issue I can not figure out. I have a query with several JOINS, but know my boss is asking for me to add an entire table to my query to view results. Is it possible to add a table to a query with joins? I have tried subquery but I get an EXIST error message. The only way I was able to get the information was join the table and enter every single column to my query. I hope there is an easier and more efficent way of doing this.Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-16 : 11:48:01
|
| you can simply add the new table with a join into existing query on a column which contains matching values of a table column in query. You can put * if you want to retrieve all the columns from your table(tablename.*). |
 |
|
|
hgalindo
Starting Member
2 Posts |
Posted - 2008-04-16 : 12:52:42
|
| Thanks for the help. I cant believe something so simple would work. I guess I was thinking too much into my results... |
|
|
|
|
|
|
Adding Table to query