RE: Null problem with SELECT

2003-06-03 Thread Mike Hillyer
bmysql.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,

Null problem with SELECT

2003-06-03 Thread Sparky Kopetzky
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