Ryan> I'm using teh shareware win32 version of mysql on win nt 4, sp 4. when i Ryan> run the query below, the server hangs and times out eventually. i see no Ryan> blatent errors in the sql i am coding. are there any known issues with
the Ryan> elements of eth code below on NT? it runs just fine on Linux 5.2

Ryan> ELECT * from directory, employee_divisions Ryan> LEFT JOIN divisions on Ryan> divisions.fldDivisionID=employee_divisions.fldDivisionID Ryan> LEFT JOIN programs on Ryan> programs.fldProgramID=employee_divisions.fldProgramID Ryan> WHERE ((directory.ID=employee_divisions.fldEmployeeID) Ryan> AND employee_divisions.fldPrimary='Y') Ryan> ORDER by last_name, first_name;

Hi!

I don't know of any problems with LEFT JOIN with the shareware version, but on the other hand, there has been some small fixes in the LEFT JOIN code after the shareware version was relesed.

What do you get if you you try do an EXPLAIN of the above query ?

Regards, Monty