Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help about Where Clause
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01012198
Message ID:
01012829
Views:
26
Hi Sergey,

Thank you for reply.

>>SELECT T1.code, T1.descr, T1.PercIVA, T1.PercIND, T1.IvaCEE
>> FROM T1
>> WHERE T1.IvaCEE IS NOT NULL
>> AND (T1.PercIND <> 0
>> OR NOT EXISTS (SELECT * FROM t1 T12
>> WHERE T12.code = t1.IvaCEE AND t12.PercIVA = >>t1.PercIVA))<<

Please, You means that I must create a new CA (T12) in my form or this CA is created from the SELECT ?

Bye,
Nino
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform