0 votes
92 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, 2020 by superdoer (130 points) | 92 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, 2020 by datalab (11,440 points)

251 questions

252 answers

289 comments

1,708 users

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