Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

2002-10-23 Thread Sinisa Milivojevic
Mark T. Dame writes: > [EMAIL PROTECTED] wrote: > > > > >Description: > > > > This query produces 16 results: > > > > SELECT * FROM table1 > > LEFT JOIN table2 ON (field1 = field2) > > WHERE field2 = 'something' > > ORDER BY field2,field3,field4 > > > > But this query produces 0 results: > > >

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

2002-10-23 Thread Mark T. Dame
[EMAIL PROTECTED] wrote: > > >Description: > > This query produces 16 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > > But this query produces 0 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (fi

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

2002-10-23 Thread Mark T. Dame
[EMAIL PROTECTED] wrote: > > >Description: > > This query produces 16 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > > But this query produces 0 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (fi

Bug with Query in MySQL 4.0.4/RedHat 8.0

2002-10-22 Thread mdame
>Description: This query produces 16 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER BY field2,field3,field4 But this query produces 0 results: SELECT * FROM table1 LEFT JOIN table2 ON (field1 = field2) WHERE field2 = 'something' ORDER