Astrolitterbox

Friday, September 28, 2012

SQLITE -- a useful join

Just putting it out here:
SELECT g.CALIFA_ID, g.el_major_axis*0.396, g.el_mag, g.circ_hlr*0.396, g.circ_mag, g.gc_sky, n.ba, n.pa FROM gc_new as g, nadine as n where n.CALIFA_ID = g.CALIFA_ID order by g.rowid asc
Posted by astrolitterbox at 11:05 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: python, SQLite

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2014 (3)
    • ►  March (1)
    • ►  January (2)
  • ►  2013 (117)
    • ►  December (6)
    • ►  November (23)
    • ►  October (3)
    • ►  September (3)
    • ►  August (2)
    • ►  June (12)
    • ►  May (14)
    • ►  April (12)
    • ►  March (3)
    • ►  February (14)
    • ►  January (25)
  • ▼  2012 (96)
    • ►  December (8)
    • ►  November (12)
    • ►  October (19)
    • ▼  September (5)
      • SQLITE -- a useful join
      • Deploying my inpainting code on other machines
      • making posters with LaTeX, rendering matplotlib im...
      • Getting a single file from git stash
      • opening images with ds9 from a python script
    • ►  August (25)
    • ►  May (8)
    • ►  April (13)
    • ►  March (5)
    • ►  February (1)

About Me

astrolitterbox
I am an astrophysics PhD student. My memory is short, hence this blog.
View my complete profile
Awesome Inc. theme. Powered by Blogger.