Hi, I have two joined tables (three actually, but for an example, 2 is OK)... example: Names / Function Then in names I have NameID, Name, and FunctionID, and in Function table, I havce FunctionID, and FunctionName... therefore, I need to find the Function Name of a Person, through their name... - simple engouh until this point... SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName WHERE (Functions.FunctionID = Names.FunctionID)... However, in some cases, Names.FunctionID might be empty, or not match anything in Functions table, and in this case I want the Functions.FunctionName to show up as null, or empty... I have been told that in MS Sql, the query would be something like the above, with the where like this: WHERE (Names.FunctionID=*Functions.FunctionID) This did not work in MySQL 3.23.30... Can you help? Thanks! PS: Please reply directly to me... (Reply All)... Thanks! :) Roy Nasser CTO Vem Cá Servicos de Internet S/C Ltda. Av. Paulista 2421 14* Andar São Paulo SP Brasil 55 11 3347 3456 / 9953 8853 - cel www.jarbas.com.br [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
