P DB List"
> Sent: Monday, September 19, 2005 9:14 AM
> Subject: [PHP-DB] Subquery
>
>
> hi,
>
> can some one enlighten me on what is wrong with my query?
>
> I want to set the fax number of all the employees of a particular
> company to the company
From: "Bastien Koert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Monday, September 19, 2005 11:30 AM
Subject: RE: [PHP-DB] Subquery
> only versions 4.1 and above support subqueries...
>
> bastien
>
> >From: "Ng Hwee Hwee" <[EMAIL PROTE
Ng Hwee Hwee" <[EMAIL PROTECTED]>
> To: "PHP DB List"
> Sent: Monday, September 19, 2005 9:14 AM
> Subject: [PHP-DB] Subquery
>
>
> hi,
>
> can some one enlighten me on what is wrong with my query?
>
> I want to set the fax number of all the
only versions 4.1 and above support subqueries...
bastien
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "PHP DB List"
Subject: [PHP-DB] Subquery
Date: Mon, 19 Sep 2005 10:14:34 +0800
hi,
can some one enlighten me on what is wrong with my query?
I want to set
i hope it's helping
sql code:
UPDATE T020Employee SET T020FaxNo = T010FaxNo
FROM T020Employee a JOIN T010Company b ON a.T020CoCd =b.T010CoCd
- Original Message -
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "PHP DB List"
Sent: Monday, September 19
hi,
can some one enlighten me on what is wrong with my query?
I want to set the fax number of all the employees of a particular company to
the company's fax number. This is because the employees do not have personal
fax machines, thus instead of just leaving T020FaxNo blank, I want to update
it w
I'm trying to use a delete subquery in Oracle (using SQL) and it is preventing me from
deleting when no records are found in the SELECT statement.
DELETE roles WHERE roleid NOT IN (SELECT DISTINCT roleid FROM users WHERE
roleid='Staff Member';
There are no records in the USERS table that
