Re: FN-FORUM: sql question

date posted 11th August 2003 22:17

Thanks - I got it working around lunch time using your suggestion plus
creating a temporary table. My Mouse then gave up the ghost - the weather
must have beeen to much for it.

Pam




----- Original Message -----
From: "David Zverina" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, August 10, 2003 6:22 PM
Subject: Re: FN-FORUM: sql question


>
> select keycol from table_a where keycol not in (select keycol from
> table_b)
>
> can be rewritten for MySQL as:
>
> select a.keycol from table_a a left outer join table_b b on (a.keycol =
> b.keycol) where b.keycoll is null;
>
> That should help you convert the query if you are indeed running on
> MySQL.
>
> Dave
>
> On Sun, 2003-08-10 at 18:12, PAMELA WHITTAKER wrote:
> > O Dear. it is still failing even when SELECT Employee_Id FROM
> > greensplash_employees_per_project where Project_Id = 18 does find
something.
> > Any other ideas please.
> >
> > Thanks
> > Pam
> >
> >
> > ----- Original Message -----
> > From: "PAMELA WHITTAKER" [EMAIL REMOVED]
> > To: [EMAIL REMOVED]
> > Sent: Sunday, August 10, 2003 5:56 PM
> > Subject: Re: FN-FORUM: sql question
> >
> >
> > >
> > > OOPS - I have just realised that "SELECT Employee_Id FROM
> > > greensplash_employees_per_project where Project_Id = '18' " won't find
> > > anything. No wonder it is failing.
> > >
> > > Thanks
> > > Pam
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Alan Sheppard" [EMAIL REMOVED]
> > > To: [EMAIL REMOVED]
> > > Sent: Sunday, August 10, 2003 5:49 PM
> > > Subject: RE: FN-FORUM: sql question
> > >
> > >
> > > >
> > > > Pam
> > > >
> > > > Is project_id a numeric and your testing against a string '18' ?
> > > >
> > > > Alan S
> > > >
> > > > On 10 August 2003 17:42, PAMELA WHITTAKER [EMAIL REMOVED]
> > > wrote:
> > > > >
> > > > > I am getting the following error
> > > > > You have an error in your SQL syntax near 'SELECT Employee_Id FROM
> > > > > greensplash_employees_per_project where Project_Id = '18' at line
1.
> > > > >
> > > > > I have set the sql string as follows
> > > > >
> > > > > $sqlstring = "SELECT Employee_Id, Employee_Forename,
Employee_Surname
> > > FROM
> > > > > greensplash_employees_details where Employee_Status = 'Active' AND
> > > > > Employee_Id NOT IN (SELECT Employee_Id FROM
> > > > > greensplash_employees_per_project where Project_Id = '" .
> > > > > $row_Project_Id['Project_Id'] . "') Order By Employee_Forename";
> > > > >
> > > > > and echo prints out
> > > > >
> > > > > SELECT Employee_Id, Employee_Forename, Employee_Surname FROM
> > > > > greensplash_employees_details where Employee_Status = 'Active' AND
> > > > > Employee_Id NOT IN (SELECT Employee_Id FROM
> > > > > greensplash_employees_per_project where Project_Id = '18') Order
By
> > > > > Employee_Forename
> > > > >
> > > >
> > > >
> > > >
> > > > ==========
> > > > fido.net are pleased to sponsor these Freelancers messages. For all
> > > > your web hosting needs check out http://www.fido.net/ with hosting
> > > > packages starting from just 46.95 a year including VAT.
> > > > Free 0871 Fax2Email numbers also available online!
> > > > http://www.fido.net/ - the internet made simple! - 0800 1072 666
> > > >
> > > > To advertise here: http://www.freelancers.net/advertising.html
> > > >
> > > >
> > > ==========
> > > fido.net are pleased to sponsor these Freelancers messages. For all
> > > your web hosting needs check out http://www.fido.net/ with hosting
> > > packages starting from just 46.95 a year including VAT.
> > > Free 0871 Fax2Email numbers also available online!
> > > http://www.fido.net/ - the internet made simple! - 0800 1072 666
> > >
> > > To advertise here: http://www.freelancers.net/advertising.html
> > >
> > >
> > ==========
> > fido.net are pleased to sponsor these Freelancers messages. For all
> > your web hosting needs check out http://www.fido.net/ with hosting
> > packages starting from just 46.95 a year including VAT.
> > Free 0871 Fax2Email numbers also available online!
> > http://www.fido.net/ - the internet made simple! - 0800 1072 666
> >
> > To advertise here: http://www.freelancers.net/advertising.html
> >
> >
> ==========
> fido.net are pleased to sponsor these Freelancers messages. For all
> your web hosting needs check out http://www.fido.net/ with hosting
> packages starting from just £46.95 a year including VAT.
> Free 0871 Fax2Email numbers also available online!
> http://www.fido.net/ - the internet made simple! - 0800 1072 666
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>