Link to home
Start Free TrialLog in
Avatar of kris_sk2012
kris_sk2012Flag for United States of America

asked on

Access query help

SELECT DISTINCT [1_sq3_b_len1].adId, [1_sq3_b_len1].pk_ad_len_output, [1_sq3_b_len1].b_id AS d_id, [1_sq3_b_len1].b_db AS d_db, [1_sq3_b_len1].b_t AS d_t, [1_sq3_b_len1].b_cl AS d_cl, [1_sq3_b_len1].Int1, [1_sq3_b_len1].rer1, [1_sq3_b_len1].Con1, [1_sq3_b_len1].Rab1, t_rt_el.db AS Db1, t_rt_el.tl AS t1, t_rt_el.column AS Col1, [1_sq3_b_len1].Int2, [1_sq3_b_len1].rer2, [1_sq3_b_len1].Con2, [1_sq3_b_len1].Rab2, t_rt_el_1.db AS Db2, t_rt_el_1.tl AS t2, t_rt_el_1.column AS Col2, [1_sq3_b_len1].Int3, [1_sq3_b_len1].rer3, [1_sq3_b_len1].Con3, [1_sq3_b_len1].Rab3, t_rt_el_2.db AS Db3, t_rt_el_2.tl AS t3, t_rt_el_2.column AS Col3, [1_sq3_b_len1].Int4, [1_sq3_b_len1].rer4, [1_sq3_b_len1].Con4, [1_sq3_b_len1].Rab4, t_rt_el_3.db AS Db4, t_rt_el_3.tl AS t4, t_rt_el_3.column AS Col4, [1_sq3_b_len1].Int5, [1_sq3_b_len1].rer5, [1_sq3_b_len1].Con5, [1_sq3_b_len1].Rab5, t_rt_el_4.db AS Db5, t_rt_el_4.tl AS t5, t_rt_el_4.column AS Col5, [1_sq3_b_len1].Int6, [1_sq3_b_len1].rer6, [1_sq3_b_len1].Con6, [1_sq3_b_len1].Rab6, t_rt_el_5.db AS Db6, t_rt_el_5.tl AS t6, t_rt_el_5.column AS Col6, [1_sq3_b_len1].Int7, [1_sq3_b_len1].Con7, [1_sq3_b_len1].rer7, [1_sq3_b_len1].Rab7, t_rt_el_6.db AS Db7, t_rt_el_6.tl AS t7, t_rt_el_6.column AS Col7, [1_sq3_b_len1].Int8, [1_sq3_b_len1].rer8, [1_sq3_b_len1].Con8, [1_sq3_b_len1].Rab8, t_rt_el_7.db AS Db8, t_rt_el_7.tl AS t8, t_rt_el_7.column AS Col8, [1_sq3_b_len1].Int9, [1_sq3_b_len1].rer9, [1_sq3_b_len1].Con9, [1_sq3_b_len1].Rab9, t_rt_el_8.db AS Db9, t_rt_el_8.tl AS t9, t_rt_el_8.column AS Col9, [1_sq3_b_len1].Int10, [1_sq3_b_len1].rer10, [1_sq3_b_len1].Con10, [1_sq3_b_len1].Rab10, t_rt_el_9.db AS Db10, t_rt_el_9.tl AS t10, t_rt_el_9.column AS Col10, [1_sq3_b_len1].Int11, [1_sq3_b_len1].rer11, [1_sq3_b_len1].Con11, [1_sq3_b_len1].Rab11, t_rt_el_10.db AS Db11, t_rt_el_10.tl AS t11, t_rt_el_10.column AS Col11, [1_sq3_b_len1].Int12, [1_sq3_b_len1].rer12, [1_sq3_b_len1].Con12, [1_sq3_b_len1].Rab12, t_rt_el_11.db AS Db12, t_rt_el_11.tl AS t12, t_rt_el_11.column AS Co12, [1_sq3_b_len1].Int13, [1_sq3_b_len1].rer13, [1_sq3_b_len1].Con13, [1_sq3_b_len1].Rab13, t_rt_el_12.db AS Db13, t_rt_el_12.tl AS t13, t_rt_el_12.column AS Col13, [1_sq3_b_len1].Int14, [1_sq3_b_len1].rer14, [1_sq3_b_len1].Con14, [1_sq3_b_len1].Rab14, t_rt_el_13.db AS Db14, t_rt_el_13.tl AS t14, t_rt_el_13.column AS Col14, [1_sq3_b_len1].Int15, [1_sq3_b_len1].rer15, [1_sq3_b_len1].Con15, [1_sq3_b_len1].Rab15, t_rt_el_14.db AS Db15, t_rt_el_14.tl AS t15, t_rt_el_14.column AS Col15, [1_sq3_b_len1].Int16, [1_sq3_b_len1].rer16, [1_sq3_b_len1].Con16, [1_sq3_b_len1].Rab16, t_rt_el_15.db AS Db16, t_rt_el_15.tl AS t16, t_rt_el_15.column AS Col16
FROM (((((((((((((((1_sq3_b_len1 LEFT JOIN t_rt_el ON [1_sq3_b_len1].Rab1 = t_rt_el.pk_el) LEFT JOIN t_rt_el AS t_rt_el_1 ON [1_sq3_b_len1].Rab2 = t_rt_el_1.pk_el) LEFT JOIN t_rt_el AS t_rt_el_2 ON [1_sq3_b_len1].Rab3 = t_rt_el_2.pk_el) LEFT JOIN t_rt_el AS t_rt_el_3 ON [1_sq3_b_len1].Rab4 = t_rt_el_3.pk_el) LEFT JOIN t_rt_el AS t_rt_el_4 ON [1_sq3_b_len1].Rab5 = t_rt_el_4.pk_el) LEFT JOIN t_rt_el AS t_rt_el_5 ON [1_sq3_b_len1].Rab6 = t_rt_el_5.pk_el) LEFT JOIN t_rt_el AS t_rt_el_6 ON [1_sq3_b_len1].Rab7 = t_rt_el_6.pk_el) LEFT JOIN t_rt_el AS t_rt_el_7 ON [1_sq3_b_len1].Rab8 = t_rt_el_7.pk_el) LEFT JOIN t_rt_el AS t_rt_el_8 ON [1_sq3_b_len1].Rab9 = t_rt_el_8.pk_el) LEFT JOIN t_rt_el AS t_rt_el_9 ON [1_sq3_b_len1].Rab10 = t_rt_el_9.pk_el) LEFT JOIN t_rt_el AS t_rt_el_10 ON [1_sq3_b_len1].Rab11 = t_rt_el_10.pk_el) LEFT JOIN t_rt_el AS t_rt_el_11 ON [1_sq3_b_len1].Rab12 = t_rt_el_11.pk_el) LEFT JOIN t_rt_el AS t_rt_el_12 ON [1_sq3_b_len1].Rab13 = t_rt_el_12.pk_el) LEFT JOIN t_rt_el AS t_rt_el_13 ON [1_sq3_b_len1].Rab14 = t_rt_el_13.pk_el) LEFT JOIN t_rt_el AS t_rt_el_14 ON [1_sq3_b_len1].Rab15 = t_rt_el_14.pk_el) LEFT JOIN t_rt_el AS t_rt_el_15 ON [1_sq3_b_len1].Rab16 = t_rt_el_15.pk_el;

Open in new window

When I try to run the below query, I get an Access error message that the result size exceeds 2GB. I know that that's not true with this since it was run in the past. Can you please see what's wrong with this?
ASKER CERTIFIED SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial