Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creacion de un select
Message
 
To
21/10/2011 16:19:45
Luis Parada
Prosoft´s de Venezuela, C.A.
Valencia, Venezuela
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01527069
Message ID:
01527070
Views:
52
Likes (1)
>Muy Buenas Tarde.
>
>Tengo 3 tablas llamadas.-
>1.- Factura (co_cli)
>2.- clientes (co_cli,co_zon)
>3.- zona (co_zon)
>
>¿Cual seria la sintaxis para la creacion de un SELECT en donde muestre todos los campos de la tabla FACTURA, dependiente de una determinada zona?.
>
>muchas gracias de antemano.
If you're asking what the select statement would be that would return all the fields of the factura table in one specific zone say YouZona, try

Select factura.* from factura, clientes where factura.co_cli = clientes.co_cli and co_zon = YourZona.

Hope this helps, and good luck.

Marc

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform