Hope this helps:
select min(ctime), max(ctime) from tbl_a where ctime != "-00-00
00:00:00"
Best regards,
Diego
- Original Message -
From: "Xiaobo Chen" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 13, 2006 11:17 AM
Subject: simple query
Hi, all
I have a table which has a co
Hi Shaun,
You could use the following statement:
INSERT INTO Allocations(Project_ID, User_ID, YES_COLUMN)
SELECT P.Project_ID, U.User_ID, 'Yes'
FROM Users U, Projects P, Clients C
WHERE P.Client_ID = C.Client_ID
AND U.Client_ID = C.Client_ID
AND Project_ID =".$project_id)
Please replace YES_CO
