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 |
|
InF3sted
Starting Member
18 Posts |
 Posted - 2008-09-26 : 08:55:01
|
| how to create virtual table from three tablestable one tStatTelekomtable two tStatTelenortable three tStatVipi need to create one table vstat,any solutions? |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-09-26 : 08:58:55
|
| you mean a VIEW (read about them in Books Online)? start with a select query that joins all 3 togetherEm |
 |
|
|
InF3sted
Starting Member
18 Posts |
Posted - 2008-09-26 : 09:00:23
|
| yeah view,hell but i don't know how to join them? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-09-26 : 09:01:42
|
| well, logically how are they related to each other? show us your table definitionsEm |
|
|
|
InF3sted
Starting Member
18 Posts |
Posted - 2008-09-26 : 09:04:47
|
| they are all in one base dbo.itvContentHR they all have row Opcija za glasanje and all Have BrojGlasova row and the first one have ImeKandidata thats it???? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-09-26 : 09:06:56
|
| i have no idea what you just saidpost your table definitions and some sample dataEm |
|
|
|
InF3sted
Starting Member
18 Posts |
Posted - 2008-09-26 : 09:09:24
|
| and final table needs to have tj Vstatrows OpcijazaGlasanje ,ImeKandidata ,Br.Glasova Telekom, br.Glasova Telenor, Br.Glasova Vip, UkupnoGlasova ? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-09-26 : 09:11:52
|
| i have no idea what you just saidpost your table definitions and some sample dataEm |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 09:19:26
|
| Read this first and you will get an answer.http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
virtual table