[thelist] SQL question

Lauri Vain lauri_lists at tharapita.com
Thu Aug 22 16:15:01 CDT 2002


> SELECT * FROM first as f, second as s
> WHERE  f.comp_id = 1
> AND f.comp_id = s.comp_id
> AND s.www_id IN (2,4)

That unfortunately translates to conditions where s.www_id is either 2
OR 4.  Note the "OR"... it should be "AND".

I will check into Joshua's and David's ideas. This system was on MySQL,
which does not support subselects, so that might not work. Fingers
crossed.

Thanks,
Lauri




More information about the thelist mailing list