0 votes
384 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) | 384 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.9k points)

498 questions

505 answers

497 comments

679 users

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

Categories