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]
