Re: FN-FORUM: mysql!

date posted 1st June 2006 22:04

On Thursday 01 Jun 2006 12:33 am, [EMAIL REMOVED] wrote:
> thaks to all that replied .. i have eventually found something i wanted
> after playing in phpmyadmin for a few hours! it invloved sub querys
>
> SELECT * FROM times WHERE NOT EXISTS(SELECT * FROM bookings WHERE
> times.time_id =3Dbookings.time_id AND bookings.book_date=3D'2006-5-10' =
)

Eeeew. Could you not get a join to do what you wanted?

--=20
5: When responding to a post, delete all information that is not
strictly necessary. This includes the freelancers tag line and .sig
files. Delete anything you're not specifically responding to.