>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.