Table Missing ??

[NinjaTaktikz]

SELECT
      SUM(IF(increment_day < '2010-06-01',SUM(vdat_2992.counts),SUM(vdat_2449.clicktositeindicator))) as CTS
FROM
      (
        SELECT * FROM vdat_2874 WHERE increment_day >= '2010-06-01'
        UNION
        SELECT * FROM vdat_2992 WHERE increment_day <= '2010-06-01'
      ) detail    
WHERE
      campaignid IN (1633605)

 

I keep getting error saying

Category Timestamp Duration Message Line Position

Error 7/14/2011 12:00:44 PM 0:00:11.875 <link> - MySQL Database Error: Unknown column 'vdat_2992.counts' in 'field list' 1 0

 

What am I doing wrong. I even gave the database table in front of the column. Please Help.

 

Thank You

 

Gary

[requinix]

The only table referenced in that query is "detail". There is neither a "vdat_2992" nor a "vdat_2449".

 

Are you missing a couple JOINs?

[fenway]

No, the OP is still referring to the derived table aliases that dont' exist.

[ebmigue]

@OP

 

Perhaps,

SELECT
      SUM(IF(increment_day < '2010-06-01',SUM(detail.counts),SUM(detail.clicktositeindicator))) as CTS
FROM
      (
        SELECT * FROM vdat_2874 WHERE increment_day >= '2010-06-01'
        UNION
        SELECT * FROM vdat_2992 WHERE increment_day <= '2010-06-01'
      ) detail    
WHERE
      campaignid IN (1633605)

will do?

 

Hope it helps.