fork download
copy 
  1. SELECT
  2.     location.*, 1 as set_hours
  3. FROM
  4.     location
  5. WHERE
  6.     EXISTS
  7.     (
  8.         SELECT
  9.             *
  10.         FROM
  11.             hours
  12.         WHERE
  13.             location.location_id = hours.hours_locationid
  14.     )
  15. UNION
  16. SELECT
  17.     location.*, 0 as set_hours
  18. FROM
  19.     location
  20. WHERE
  21.     NOT EXISTS
  22.     (
  23.         SELECT
  24.             *
  25.         FROM
  26.             hours
  27.         WHERE
  28.             location.location_id = hours.hours_locationid
  29.     )
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/zRkHF
language:
SQLite (sqlite 3.27.2)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!