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: mysql@lists.mysql.com
Sent: Monday, March 13, 2006 11:17 AM
Subject: simple query
Hi, all
I have a
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