Sentencias bd

Solo disponible en BuenasTareas
  • Páginas : 2 (295 palabras )
  • Descarga(s) : 0
  • Publicado : 13 de septiembre de 2012
Leer documento completo
Vista previa del texto
1) Select S.Nombre
From Sucursales as S, Empresa as W.
Where S.Cedula_Juridica = W.Cedula_Juridica and W.Razon_Social = “El Banco Feliz”

2) Select W.Razon_SocialFrom Empresa as W


3) Select E.Nombre
From Empleados as E, Sucursales as S, Empresa as W
Where E.Cod_Sucursal = S.Cod_Sucursal and S.Cedula_Juridica = W.Cedula_Juridica andW.Razon_Social = “El Banco Feliz”

4) Select R.Descripcion
From Servicios as R, Empresa as W, ServiciosxEmpresa as RxW.
Where W.Razin_Social = “Diente Alegre” and W.Cedula_Juridica =SxE.Cedula_Juridica and RxW.Cod_Servicio = R.Cod_Servicio and R.Costo > 10 000

5) Select C.Nombre
From Clientes as C, ClientexServicio as CxR, Servicios as R.
Where C.ID_Cliente =CxR.ID_Cliente and CxR.Cod_Servicio = R.Cod_Servicio and R.Descripcion = “Blanqueamiento”.


6) Select E.Nombre
From Empleado as E, Sucursales as S.
Where E.Cod_Sucursal =S.Cod_Sucursal and S.Provincia = “San Jose”.


7) Select T.Telefono
From Tel_Clientes as T, Clientes as C.
Where T.ID_Cliente = C.ID_Cliente and C.ID_Cliente = “25”


8) SelectS.nombre, S.Provincia, S.telefono
From Sucursales as S, Empresa as W.
Where S.Cedula_Juridica = W.Cedula_Juridica and W.Razon_Social = “El Zapatito”


9) Select W.Ced_JuridicaFrom Empresa as W.
Where W.Mercado = “Financiero” or W.Mercado = “Salud”.


10) Select E.Nombre
From Empleados as E.
Where E.Area = “Cobros”


11) Select E.NombreFrom Empleados as E, Sucursales as S, Empresa as W.
Where E.Cod_Sucursal = S.Cod_Sucursal and S.Cedula_Juridica = W.Cedula_Juridica and W.Mercado = “Salud”


12) SelectR.Descripcion
From Servicios as R.



13) Select R.Descripcion
From Servicios as R.
Where R.Costo < 50 000


14) Select R.Descripcion
From Servicios as R,...
tracking img