Re: Complicated query

From: Denis McMahon <denismfmcmahon_at_gmail.com>
Date: Wed, 10 Dec 2014 00:15:23 +0000 (UTC)
Message-ID: <m683ar$pjq$1_at_dont-email.me>


On Mon, 08 Dec 2014 22:00:57 -0500, Shelly wrote:

> On 12/7/2014 12:05 PM, richard wrote:

>> I know this will piss off normalized Jerry Stuckle, but I'd just as
>> soon use one table.
>> Columns would be ID Question Achoice Bchoice Cchoice Dchoice Correct
>>
>> Now all you need to do is retrieve the row for each ID as needed.

> Of course, and if *I* had designed the table structures, that is what I > would have done as well.

You are kidding us, right?

Are you seriously working with Oracle products and preaching non normalised database design?

Also you seem to have lost the instance information somewhere along the way. Hope that wasn't important.

-- 
Denis McMahon, denismfmcmahon_at_gmail.com
Received on Wed Dec 10 2014 - 01:15:23 CET

Original text of this message