FPD25b SQL SELECT filter subset of a query result based

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

FPD25b SQL SELECT filter subset of a query result based

Message

16/07/2001 02:57:16

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, Inde

14/07/2001 14:03:02

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: FPD25b SQL SELECT filter subset of a query result based

Divers

Thread ID:

00530650

Message ID:

00530863

Vues:

Thanks for the help and I have found a solution based on it as follows:


scust.packageid + DTOS(scust.applicdt) IN ( ;
        SELECT sc.packageid + DTOS(MAX(scust.applicdt)) ;
		FROM a25scust sc ;
		GROUP sc.packageid) AND ;
<\pre>

Regards
Bhavbhuti

Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
 http://venussoftop.tripod.com 
___________________________________________
 venussoftop@gmail.com 
___________________________________________

Répondre

Fil

Voir

Click here to load this message in the networking platform