By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

Query for showing contents of 5 tables

P: n/a
I need a SQL query that will allow me to show the contents of all 5
relational tables. Can anyone help?
Employee table
Dept Table
Dept Locations Table
Project Table
Works on Table etc....

Thanks in advance.

Aug 4 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

Grant wrote:
I need a SQL query that will allow me to show the contents of all 5
relational tables. Can anyone help?
Employee table
Dept Table
Dept Locations Table
Project Table
Works on Table etc....

Thanks in advance.
Whoa. Looks like homework straight out of Elmasri & Navathe.

Gee... I dunno... what happens if you link PK to FK so all the tables
are in the query? Enjoy the homework. Have you read the chapter on
SQL yet? You might want to start there.

Aug 4 '06 #2

P: n/a
what's the use ....its fun talkin to people like you.
:)

Who is this btw?
pi********@hotmail.com wrote:
Grant wrote:
I need a SQL query that will allow me to show the contents of all 5
relational tables. Can anyone help?
Employee table
Dept Table
Dept Locations Table
Project Table
Works on Table etc....

Thanks in advance.

Whoa. Looks like homework straight out of Elmasri & Navathe.

Gee... I dunno... what happens if you link PK to FK so all the tables
are in the query? Enjoy the homework. Have you read the chapter on
SQL yet? You might want to start there.
Aug 4 '06 #3

P: n/a
"Josh" wrote
what's the use ....its fun talkin to people like you.

:)
But, it's more than a little irritating to keep getting questions from
slackers who aren't willing to invest even the most minimal effort in
learning the subject they signed up for. {Note: no smiley.}
Who is this btw?
pi********@hotmail.com wrote:
Piet is a long-time contributor to this newsgroup who provides excellent
answers to some real "stumper" questions, on a regular, ongoing basis. And,
he has more patience and tolerance for slacker students than some others --
notice he only pointed out the obvious, and did not call the student any
"names," not even "slacker" which is equally obvious.

Larry Linson
Microsoft Access MVP
Aug 4 '06 #4

P: n/a
Josh,
if you don't believe me, go to a university bookstore and find a copy
of Elmasri & Navathe and read the chapters on SQL yourself. A bit of a
coincidence that the question is about something that comes directly
from the textbook? The sad thing is that if you read the table of
contents, you can skip straight to the SQL chapters and read how to
write queries. The only difference there is that Oracle does the joins
in the Where clause and Access in the From clause.

Aug 6 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.