daily pastebin goal
14%
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select HTAR_AcomodacionId, HOTA_Acomodacion, HTAR_CategoriaId,
  2.         Categoria, HTAR_PrecioTar from HotTarifas,
  3.         (Select HotCategoriasId, CAT_Cat1 as Categoria from HotCategorias
  4.             where HotCategoriasId      
  5.         in ( SELECT HTAR_CategoriaId FROM HotTarifas      
  6.                   Where HTAR_HotelID = 2
  7.                   and HTAR_AcomodacionId = 3))
  8.            as NomCategoria, HotAcomodaciones
  9.            Where HTAR_CategoriaId        
  10.         in (SELECT HTAR_CategoriaId FROM Hot
  11.           Where HTAR_HotelID = 2
  12.            and HTAR_AcomodacionId = 3)
  13.            and HotCategoriasId = HTAR_CategoriaId
  14.            and HotAcomodacionesId = HTAR_AcomodacionId
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top