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 (field1 = field2)

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 (field1 = field2)

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: SELECT * FROM table1

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