Re: Conversion from Access JOIN syntax to MySQL JOIN syntax...

2001-06-26 Thread Joshua J. Kugler
inal Message - > From: "Joshua J. Kugler" <[EMAIL PROTECTED]> > To: "MySQL" <[EMAIL PROTECTED]> > Sent: Wednesday, June 27, 2001 2:47 > Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax... > > > Yes, I've read the

Re: Conversion from Access JOIN syntax to MySQL JOIN syntax...

2001-06-26 Thread Rolf Hopkins
2:47 Subject: Conversion from Access JOIN syntax to MySQL JOIN syntax... > Yes, I've read the docs on JOIN syntax, and search the list archives for > similar information. > > I have this query: > > SELECT leg_activity.activity_date, leg_transitions.trans_desc, > leg_text.le

Conversion from Access JOIN syntax to MySQL JOIN syntax...

2001-06-26 Thread Joshua J. Kugler
Yes, I've read the docs on JOIN syntax, and search the list archives for similar information. I have this query: SELECT leg_activity.activity_date, leg_transitions.trans_desc, leg_text.leg_version, body_list.body_name FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_activity