0 votes
371 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) | 371 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)

467 questions

479 answers

477 comments

667 users

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

Categories