Re: Joining tables returns duplicated rows

2002-02-02 Thread Sinisa Milivojevic
Greg Bailey writes: > >Description: > > Joining multiple tables together in a select statement with where clauses > using the "IN (...)" construct generate duplicated output rows. Hi! I tested your case with 4.0.2 and got identical results from both queries. This was some bug probably fixed l

Joining tables returns duplicated rows

2002-02-01 Thread Greg Bailey
>Description: Joining multiple tables together in a select statement with where clauses using the "IN (...)" construct generate duplicated output rows. >How-To-Repeat: 1. ==>>Load the following into the "test_bug" database: # MySQL dump 8.14 # # Host: localhostDatabase: test_bug #