Help with syntax error

2002-04-02 Thread Victoria Reznichenko
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>

Re: Help with syntax error

2002-04-02 Thread Jim Philips
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

Help with syntax error

2002-04-02 Thread jim and lois flaherty
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