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> pick out the test name but I dont want duplicate. I made the column unique
jalf> in table phistory ( column testname)
jalf> I wanted to write a SQL query for this
jalf> select distinct testname from testhistory where testname not in (select
jalf> distinct testname in phistory)
jalf> but I get a syntax error
MySQL doesn't currently support sub-selects. Try to use JOIN in your
SELECT statements. You can read about JOIN at:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
http://www.mysql.com/doc/J/O/JOIN.html
jalf> Help
jalf> Jim
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
