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 |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2002-10-29 : 09:24:44
|
| I want to make query from 3 tables.Is making Views and quey from them is the onlt way? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-10-29 : 09:29:30
|
| Normally you would join them together. Look up joining tables in the transact SQL help. |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-10-29 : 09:39:22
|
| In addition to a view you can wrap the query in a stored procedure, but go with the view if you are planning on joining the data further or in other ways tweaking the output.hth,JustinHave you hugged your SQL Server today? |
|
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2002-10-29 : 10:14:58
|
| Thank you for your replies.I got the point now. |
|
|
|
|
|
|
Query from 3 table