Re: Joining tables using "IN (...)" clause returns duplicate rows

2002-02-04 Thread Greg Bailey
47 that was fixed a "long time ago" as Mr. Milivojevic states, wouldn't I expect it to find its way into the 3.23.X series as the production series? I really like MySQL and don't mean this as any type of a flame, just wondering what the versions mean. Thanks for any insight an

Joining tables returns duplicated rows

2002-02-01 Thread Greg Bailey
ws 3. ==>>Execute the query "query_failure.sql" which produces the failed output: (Note the "IN (...)" clauses should have no effect on the output) select * from event, status, severity where event.status = status.status and event.severity = severity.