Grant, Could you please be a bit more specific? What do you mean when you say "I want to create a query that will take all the fields in. If no end_date exists then set to NULL."?
Thanks -----Original Message----- From: Grant Cooper [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 4:11 AM To: [EMAIL PROTECTED] Subject: Is query possible? (Newbie) I have 2 tables used for an online calendar... first table fields: primary_key , start_date, event_name, event_description second table fields: primary_key, end_date Tables fields are shortened and can't be changed. My second table only contains events that have a end date. I want to create a query that will take all the fields in. If no end_date exists then set to NULL. Been playing with it all day. Hoping some advance function exists. I thought of using a temp table but there must be a better way. -- 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]
