Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difference with VFP6 and VFP9 interpretations
Message
De
24/08/2007 06:12:08
 
 
À
24/08/2007 05:44:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01250111
Message ID:
01250123
Vues:
11
I don't remeber exactly, but try this
SELECT A.bs,A.val,A.key_,A.otd,A.numb,A.summ_i,A.summ_iv,B.prizn,B.open_date,L_recli.* FROM t_p A LEFT JOIN L_po1 B ;
ON A.bs+A.val+A.key_+A.otd+A.numb=B.bs+B.val+B.key_+B.otd+B.numb LEFT  JOIN  L_recli ;
ON B.kod_client=L_recli.kod_client  WHERE A.summ_i>0 AND ;
(Left(A.bs,3)='423' or Left(A.bs,3)='426' or Left(A.bs,3)='522' or ;
((A.bs='40806' or A.bs='40809' or A.bs='40812' or A.bs='40813' or A.bs='40814' or A.bs='40815') and B.prizn like '%F_%') ;
 or A.bs in ('40803','40817','40820','47603','47605','52404')) ;
INTO table SYS(2023)+"\L_dog012" ORDER BY L_recli.kod_client
>Thank you Tore for answer!
>But I don't understand what function in my select statement is invalid
>
>SELECT A.bs,A.val,A.key_,A.otd,A.numb,A.summ_i,A.summ_iv,B.prizn,B.open_date,C.* FROM t_p A LEFT JOIN L_po1 B ;
>ON A.bs+A.val+A.key_+A.otd+A.numb=B.bs+B.val+B.key_+B.otd+B.numb LEFT  JOIN  L_recli C;
>ON B.kod_client=C.kod_client  WHERE A.summ_i>0 AND ;
>(Left(A.bs,3)='423' or Left(A.bs,3)='426' or Left(A.bs,3)='522' or ;
>((A.bs='40806' or A.bs='40809' or A.bs='40812' or A.bs='40813' or A.bs='40814' or A.bs='40815') and B.prizn like '%F_%') ;
> or A.bs in ('40803','40817','40820','47603','47605','52404')) ;
>INTO table SYS(2023)+"\L_dog012" ORDER BY C.kod_client
>
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform