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

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 31 Dec 2003 09:09:25 -0800
Message-ID: <4b5394b2.0312310909.6593490a_at_posting.google.com>


enavarro_at_attglobal.net (Emilio) wrote in message news:<7551aabf.0312301543.4ae1891f_at_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. Received on Wed Dec 31 2003 - 18:09:25 CET

Original text of this message