How do I select 1 field from multiple tables (about 50 tables) in sql statement?
I need to get a table contains, Date field then the 50's fields each field from a table.
Used this statement but it doesn't work form more than 31 tables, when put more than 31 tables error message says (Query is too complex)
select t1.day_date,t1.at_max,t2.at_max,t3.at_max,t4.at_max,t5.at_max,t6.at_max,t7.at_max,t8.at_max,t9.at_max,t10.at_max,t11.at_max,t12.at_max,t13.at_max,t14.at_max,t15.at_max,t16.at_max,t17.at_max,t18.at_max,t19.at_max,t20.at_max,t21.at_max,t22.at_max,t23.at_max,t24.at_max,t25.at_max,t26.at_max,t27.at_max,t28.at_max,t29.at_max,t30.at_max,t31.at_max
from t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,t31
where
(t1.day_date = t2.day_date) and (t1.day_date = t3.day_date) and (t1.day_date = t4.day_date) and (t1.day_date = t5.day_date) and (t1.day_date = t6.day_date) and (t1.day_date = t7.day_date) and (t1.day_date = t8.day_date) and (t1.day_date = t9.day_date) and (t1.day_date = t10.day_date) and (t1.day_date = t11.day_date) and (t1.day_date = t12.day_date) and (t1.day_date = t13.day_date) and (t1.day_date = t14.day_date) and (t1.day_date = t15.day_date) and (t1.day_date = t16.day_date) and (t1.day_date = t17.day_date) and (t1.day_date = t18.day_date) and (t1.day_date = t19.day_date) and (t1.day_date = t20.day_date) and (t1.day_date = t21.day_date) and (t1.day_date = t22.day_date) and (t1.day_date = t23.day_date) and (t1.day_date = t24.day_date) and (t1.day_date = t25.day_date) and (t1.day_date = t26.day_date) and (t1.day_date = t27.day_date) and (t1.day_date = t28.day_date) and (t1.day_date = t29.day_date) and (t1.day_date = t30.day_date) and (t1.day_date = t31.day_date) and (t1.day_date between #2014/01/01# and #2014/01/31#)