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

How can I combine three tables in a View or a Procedure?

P: n/a
Hello everyone. I hope someone can help me with this. I have 3
columns called EMPLOYEE_TEST, TEST_QA and EMPLOYEE_TEST_ANSWER.

The TEST_QA table contains the following:

TEST_QA_ID | PROC_TEST_ID | TEST_QA_QUESTION | TEST_QA_CORRECT
-----------+--------------+------------------+-----------------
3| 1|First Question | 5
4| 2|Second Question | 1
5| 1|Third Question | 2
6| 3|Fourth Question | 1
7| 3|Fifth Question | 5
8| 3|Sixth Question | 2
9| 3|Seventh Question | 3

The EMPLOYEE_TEST table contains the following:

EMPLOYEE_ID | EMPLOYEE_TEST_ID
------------+------------------
3| 7

The EMPLOYEE_TEST_ANSWER table contains the following:

EMPLOYEE_TEST_ID | TEST_QA_ID | TEST_QA_CORRECT
-----------------+------------+-----------------
7| 9| 5
7| 8| 2
7| 6| 1

From these three tables I can see that the employe with ID = 3 has
answered 3 questions and two of them are correct. What I would like
to be able to do is to represent this in a view (if possible)

EMPLOYEE_ID | EMPLOYEE_TEST_ID | TOTAL_ANSWERS | CORRECT | WRONG
------------+------------------+---------------+---------+-------
3| 7| 2| 2| 1

Thank you in advance...

Emilio
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Who receives the university credits if we help, us or you?

Daniel
Jul 19 '05 #2

P: n/a
en******@attglobal.net (Emilio) wrote in message news:<75**************************@posting.google. com>...
Hello everyone. I hope someone can help me with this. I have 3
columns called EMPLOYEE_TEST, TEST_QA and EMPLOYEE_TEST_ANSWER.
You mean three TABLES, not columns.
Tables contain rows which are composed of columns which contain
values.

[]
From these three tables I can see that the employe with ID = 3 has
answered 3 questions and two of them are correct. What I would like
to be able to do is to represent this in a view (if possible)


Look in your textbook for the word JOIN. Learn that before moving on
to creating views and procedures.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.