RE: Selecting data from three tables

2006-12-01 Thread Jerry Schwartz
n Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: John Nichel [mailto:[EMAIL PROTECTED] > Sent: Friday, December 01, 2006 11:10 AM > To: mysql@lists.mysql.com > Subject: Selecting data from three tables > > Hi, > >I am ha

Re: Selecting data from three tables

2006-12-01 Thread Rolando Edwards
it a try !!! - Original Message - From: John Nichel <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, December 1, 2006 11:09:52 AM GMT-0500 US/Eastern Subject: Selecting data from three tables Hi, I am having a bit of trouble with a SQL query that I am hoping someone here

Selecting data from three tables

2006-12-01 Thread John Nichel
Hi, I am having a bit of trouble with a SQL query that I am hoping someone here can give me pointers on, or a nudge in the direction of a place which can give me a better understanding of JOINS. Running MySQL v4.0.27 Max on a RHEL4 box. I have three tables which look like this... Table