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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-26 : 11:35:52
|
| Tim writes "I have 4 tables in my Oracle DB. I would like to select all the info in each table with just one sql querry to the database.It would return the result of doing four separate (SELECT * FROM table#) for each of the tables. Thanks!" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-26 : 11:54:14
|
| I get such a kick out of these. When you submit an AskSQLTeam question, you have to read this : We answer questions on Microsoft SQL Server here. No Oracle, no Access, no ASP, no mySQL. Just Microsoft SQL Server.So, someone posts an Oracle question and says "Let's see some skills".How about "Let's see some English comprehension"....sigh.Damian |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-26 : 12:33:44
|
| Probably the well touted devloper we've all heard about recently....Don't ask us....we don't know....Brett8-) |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-04-26 : 14:13:20
|
Well there is always the "carefully designed" UNION query or a completely insane CROSS-JOIN. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 14:21:48
|
| It sounds like a homework question anyway. Just put the four selects in a stored procedure. To get the answer in one query, just execute the stored procedure.Tara |
|
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-04-26 : 17:43:32
|
| Set up some linked tables in SQL server ...... |
|
|
|
|
|
|
let's see some skills...i'm stumped :)