If I understand your question correctly, what you want is:
SELECT first_table.*, second_table.end_date FROM first_table LEFT JOIN second_table ON first_table.primary_key=second_table.primary_key cheers, Jan Sometime recently Grant Cooper said: > 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] > > -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
