Nuevo Documento De Texto.txt

  • Uploaded by: perro18u2
  • 0
  • 0
  • October 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Nuevo Documento De Texto.txt as PDF for free.

More details

  • Words: 113
  • Pages: 1
ORDER BY ordena ascendentemente, si deseas ordenar de forma utiliza DESC al final de la instrucci�n BETWEEN fecha 1 AND fecha2

descendente

permite la busqueda entre un rango

select from /TABLA/ where nom_prod like "%Deslactosado%" //TODOS LOS CAMPOS QUE CONTENGAN LA PALABRA DESLA select from /tabla/ where nom_prod like "%1 lt" ORDER BY existencia //Termine con 1 lt ordenado por existencia FOREIGN KEY(ID_PROD) REFERENCES PRODUCTO(ID_PROD) [ En la tabla que contiene la FK ] No olvides que en una consulta MULTITABLA se debe incluir la igualaci�n de la PK con la FK en la secci�n de WHERE (ver ejemplo) Select id_ped, fec_ped, producto.id_prod, prec_prod, cant_prod, prec_prod*cant_prod as subtotal From pedido, producto Where producto.id_prod=pedido.id_prod;

Related Documents

Nuevo Documento De Texto
November 2019 33
Nuevo Documento De Texto
November 2019 34
Nuevo Documento De Texto
November 2019 43

More Documents from ""

Nuevo Documento De Texto
October 2019 19
Red
October 2019 34