Re: How can I find this data?

2005-05-05 Thread shaun thornburgh
| +--++--+---+ 2 rows in set (0.00 sec) mysql Do you see my problem here?! Any advice would be greatly appreciated... Shaun From: [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: How can I find this data? Date: Wed, 4 May 2005

RE: How can I find this data?

2005-05-04 Thread Jay Blanchard
[snip] I have four tables among others in my database: Bookings, Work_Types, Practices Projects. Bookings occur in a Practice for a Project and have a Work_Type. A Practice can have many Bookings but must have one and only one Booking where the Work_Type.Day_Type = 1. This rule was introduced

Re: How can I find this data?

2005-05-04 Thread SGreen
shaun thornburgh [EMAIL PROTECTED] wrote on 05/04/2005 06:54:23 AM: Hi, I have four tables among others in my database: Bookings, Work_Types, Practices Projects. Bookings occur in a Practice for a Project and have a Work_Type. A Practice can have many Bookings but must have one and

RE: How can I find this data?

2005-05-04 Thread shaun thornburgh
@lists.mysql.com Subject: RE: How can I find this data? Date: Wed, 4 May 2005 06:36:18 -0500 [snip] I have four tables among others in my database: Bookings, Work_Types, Practices Projects. Bookings occur in a Practice for a Project and have a Work_Type. A Practice can have many Bookings but must have