Re: Complicated query

On Fri, 12 Dec 2014 11:26:18 -0500, Shelly wrote:
> On 12/12/2014 10:11 AM, Jerry Stuckle wrote:
>> They are different answers to the question in that row. Each ROW has a
>> different question - not each COLUMN. You don't have 18 columns - one
>> for each question. You have 18 rows. Each row has the question and
>> five possible answers.
>
> ...and you don't know what you are talking about. There is ONE row for
> each instance and 18 columns, ONE column for ONE answer to each of the
> 18 DIFFERENT questions for THAT instance --- in the design that the
> person (philosopher??) suggested as a single table, NOT the actual
> design that I was working with.
>
> So much like you, that you insist that you are right even when you are
> clearly wrong -- and have been corrected, what, four times now.

Here is the DDL richard posted that you said you'd use.

One question, four answers, which one's correct.

You are misremembering what you agreed to or you're misrepresenting it. Either way, Jerry's assessment of what richard posted is true.

-- 
4. Shooting is not too good for my enemies.
        --Peter Anspach's list of things to do as an Evil Overlord