Missing Table ?? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Missing Table ??

Author

Topic

Ninjataktikz
Starting Member

3 Posts

Posted - 2011-07-14 : 15:47:47

[code]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)[/code]

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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-07-14 : 16:18:01

SQLTeam is a Microsoft SQL Server website, we don't answer MySQL questions. There's a MySQL forum over at http://dbforums.com/

Ninjataktikz
Starting Member

3 Posts

Posted - 2011-07-15 : 17:33:30

quote:
Originally posted by robvolk

SQLTeam is a Microsoft SQL Server website, we don't answer MySQL questions. There's a MySQL forum over at http://dbforums.com/

Sorry about that. Thank you for the link.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources