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
: [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's fax number. This is because the employees do not have
personal
fax machines, thus instead of just leaving T020FaxNo blank, I
only versions 4.1 and above support subqueries...
bastien
From: Ng Hwee Hwee [EMAIL PROTECTED]
To: PHP DB List php-db@lists.php.net
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 the fax number
: Re: [PHP-DB] Subquery
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 php-db@lists.php.net
Sent: Monday
: Bastien Koert [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; php-db@lists.php.net
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 PROTECTED]
To: PHP DB List php-db@lists.php.net
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's fax number. This is because the employees do
not have personal fax machines, thus instead of just leaving
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