0 votes
361 views
The code I am submitting is:

SELECT ra, dec, a_image, b_image, mag_auto_i_dered, magerr_auto_i, spread_model_i, thetawin_image_i, mag_auto_r_dered, magerr_auto_r, spread_model_r, thetawin_image_r, mag_auto_g_dered, magerr_auto_g, spread_model_g, thetawin_image_g FROM des_dr1.main
WHERE dr1.MAG_AUTO_G < 18 and dr1.WAVG_SPREAD_MODEL_I + 3.0*dr1.WAVG_SPREADERR_MODEL_I > 0.005 and dr1.WAVG_SPREAD_MODEL_I + 1.0*dr1.WAVG_SPREADERR_MODEL_I > 0.003 and dr1.WAVG_SPREAD_MODEL_I - 1.0*dr1.WAVG_SPREADERR_MODEL_I > 0.001 and dr1.WAVG_SPREAD_MODEL_I > -1
by superdoer (130 points) | 361 views

1 Answer

+1 vote

In your query, maybe you need to change 

".... FROM des_dr1.main WHERE dr1.MAG_AUTO_G < 18...." 

to  

".... FROM des_dr1.main as dr1 WHERE dr1.MAG_AUTO_G < 18...." 

by datalab (21.8k points)

464 questions

476 answers

475 comments

665 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.

Categories