----- Original Message ----- 
From: "Rommel Relosa" 
Amended by Bernie Lis

project temporary abcd from orders using all


insert into abcd 

> SELECT DISTINCT ClientID,MAX(DateTimeOrder) FROM Orders GROUP BY ClientID
> 

then delete table orders and rename abcd to orders


================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/

Reply via email to