Chris W schrieb:
I have the following query...
SELECT c.NLCID, n.publishdate
FROM newsletter n
JOIN newslettersection s using (NLID)
JOIN newslettercontent c using(NLCID)
WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00
00:00:00'
I want to run an update on
update newslettercontent c set c.timestamp= (select n.publishdate from
newsletter n where
n.NLCID= c.NLCID);
This should work.
On 4/16/08, Chris W [EMAIL PROTECTED] wrote:
I have the following query...
SELECT c.NLCID, n.publishdate
FROM newsletter n
JOIN newslettersection s using (NLID)
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can get the userid using:
SELECT
update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can
To: [EMAIL PROTECTED]
Subject: an update select question
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can get the userid
gerald_clark wrote:
update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email