Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save beechovsky/19bf19be0cff0a56a75abeca47b6510c to your computer and use it in GitHub Desktop.
Save beechovsky/19bf19be0cff0a56a75abeca47b6510c to your computer and use it in GitHub Desktop.
Table Join on Vlaues
SELECT vD.multiframeID,vD.ra,vD.dec
FROM vvvDetection vD
LEFT JOIN
(VALUES
(272.113906,-20.426462),
(272.119212,-20.425275),
(272.113597,-20.405242),
(271.178448,-19.899683),
(272.091002,-20.369929),
(272.123353,-20.384221),
(272.649034,-20.617503),
(272.611384,-20.597470),
(272.296945,-20.431335),
(272.571037,-20.563430),
(272.108862,-20.319868),
(272.126689,-20.323685),
(272.132073,-20.318523),
(272.374807,-20.432054),
(272.564808,-20.505832),
(271.369565,-19.873510),
(271.985302,-20.195459),
(272.691794,-20.544885),
(271.473166,-19.907246),
(272.011015,-20.181380),
(271.411274,-19.861963),
(271.129648,-19.705184),
(272.480963,-20.405808),
(272.382140,-20.339387),
(271.942498,-20.110003),
(272.283834,-20.280495)
) v (ra, dec)
ON vD.ra BETWEEN v.ra+0.000555556 AND v.ra-0.000555556
AND vD.dec BETWEEN v.dec+0.000555556 AND v.dec-0.000555556
;
@beechovsky
Copy link
Author

Looking for values in the specified table within .00055556 (2 arcsec) of the values listed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment