You need a LEFT JOIN. SELECT blah, blah, blah FROM bite bite LEFT JOIN person agency ON agency.person_id = bite.bite_agency_id WHERE bite.bite_id = "AC-2003-0004";
Check out http://www.mysql.com/doc/en/JOIN.html to learn more about LEFT JOIN. Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Sparky Kopetzky [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 3:24 PM To: My Sql List Subject: Null problem with SELECT Greetings! I have a query for a report that accesses columns that could possibly be null. Here's an example: SELECT blah, blah, blah FROM bite bite, person agency WHERE bite.bite_id = "AC-2003-0004" AND agency.person_id = bite.bite_agency_id; bite.bite_agency_id and other fields like this could and will be null and I still want them to display as null. But the rest of the columns from the select come up empty. What can I do to allow the query to run even with the nulls? Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
