[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)
[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)
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
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