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>
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