Re: Is query possible? (Newbie)

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...

RE: Is query possible? (Newbie)

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.

Re: Is query possible? (Newbie)

On Thursday, August 14, 2003, at 08:04 PM, Jennifer Goodie wrote: 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 tab

RE: 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

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 qu