jim,
Tuesday, April 02, 2002, 2:54:13 PM, you wrote:
jalf> I have a table that recieves raw data form results for an online quiz. The
jalf> boss wants to analyse the data , I have it all going to one table for
jalf> processing. From that table of "Raw Data" I pick out what I need. I want to
jalf>
There is no support for sub-queroes in MySQL, so your second select is
getting kicked out. You probably want a left join for this.
On Tue, 2002-04-02 at 06:54, jim and lois flaherty wrote:
> I have a table that recieves raw data form results for an online quiz. The
> boss wants to analyse the da
I have a table that recieves raw data form results for an online quiz. The
boss wants to analyse the data , I have it all going to one table for
processing. From that table of "Raw Data" I pick out what I need. I want to
pick out the test name but I dont want duplicate. I made the column unique
in