Re: Complicated query
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Fri, 12 Dec 2014 13:40:40 -0500
Message-ID: <m6fcql$jgo$1_at_dont-email.me>
>
> Here is the DDL richard posted that you said you'd use.
>
> -----------
> Columns would be
> ID
> Question
> Achoice
> Bchoice
> Cchoice
> Dchoice
> Correct
> -----------
>
> 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.
>
Date: Fri, 12 Dec 2014 13:40:40 -0500
Message-ID: <m6fcql$jgo$1_at_dont-email.me>
On 12/12/2014 12:04 PM, Peter H. Coffin wrote:
> 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.
>
> -----------
> Columns would be
> ID
> Question
> Achoice
> Bchoice
> Cchoice
> Dchoice
> Correct
> -----------
>
> 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.
>
Thank you, Peter!
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Fri Dec 12 2014 - 19:40:40 CET