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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-04-19 : 17:12:00
|
| i have a table that has 9 columns that belongs to other tables. i need to retrieve one column from this table. In order to do this, do i have to join all the other tables that has similar columns? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-19 : 17:26:45
|
| SELECT ColumnNameFROM TableNameIf that's not what you want, please show us an example.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-20 : 16:12:18
|
| i have 6 interbase servers. 6 tables in each server. Want to retrieve different columns from these tables.36 tables in total.what is the best way to pull the data out everyday?im planning to create 6 link servers for every interbase server.then create 6 views for each linked server selecting the columns i need.i dont know if this is the best approach. |
|
|
|
maevr
Posting Yak Master
169 Posts |
Posted - 2007-04-20 : 18:59:16
|
| Yes I that is what I should have done. |
|
|
|
|
|
|
retrieve 1 column