Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir Ibrahim
  Where is Samir Ibrahim?
 Chekka
 Lebanon
 Samir Ibrahim
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 Tags
Subject: RE: UPDATE SQL Start from Second match
Thread ID: 209792 Message ID: 209820 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 12:39:59 PM         
   


Hi Andy

Happy new year to you and all your family.

>
> SELECT TGT.p_id, TGT.p_amount, TGT.p_status, TGT.createdate ;
> FROM MyTable TGT ;
> LEFT OUTER JOIN ( SELECT p_id, MIN( createdate ) created FROM MyTable GROUP BY p_id ) EXC ;
> ON EXC.p_id = TGT.p_id ;
> WHERE tgt.createdate > EXC.created ;
> INTO CURSOR result
>

That was very cool query result

how should I update mytable depends on this?

PS: My problem is solved, but I would like to know another solutions.

Samir R. Ibrahim
Good things Take time, Great things happend all at once. My WebLog My Website: www.cdcity.org

ENTIRE THREAD

UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 10:54:20 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 11:25:26 AM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:36:14 PM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 12:44:27 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 11:42:18 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 11:54:02 AM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 11:59:20 AM
RE: UPDATE SQL Start from Second match Posted by Stefan Wuebbe @ 12/31/2008 12:08:57 PM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:39:59 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 12/31/2008 4:39:59 PM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 1/1/2009 5:39:45 PM
RE: UPDATE SQL Start from Second match Posted by Andy Kramek @ 1/1/2009 7:42:36 PM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 1/2/2009 11:30:30 AM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 1/2/2009 10:15:20 AM
RE: UPDATE SQL Start from Second match Posted by Anders Altberg @ 12/31/2008 12:17:03 PM
RE: UPDATE SQL Start from Second match Posted by Samir Ibrahim @ 12/31/2008 12:30:08 PM