0 votes
18 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
asked Nov 5 by superdoer (130 points) | 18 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...." 

answered Nov 5 by datalab (9,260 points)

206 questions

204 answers

198 comments

1,396 users

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