Re: FN-FORUM: mysql!

date posted 1st June 2006 22:12

apart from backwards compatibility why would a join be better? does it have
performance issues?
----- Original Message -----
From: "Dom Latter" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, June 01, 2006 11:08 PM
Subject: Re: FN-FORUM: mysql!



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 =bookings.time_id AND bookings.book_date='2006-5-10' )

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

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


--
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html