(select
     `precio`,
     `nombre`
   from `bancas`
   where `precio` between 200 and 1000)
  union
  (select
     `precio`,
     `nombre`
   from `sillas`
   where `precio` between 200 and 1000)
  union
  (select
     `precio`,
     `nombre`
   from `mesas`
   where precio between 200 and 1000)