Warning: Undefined array key 111673 in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3534
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3536
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/user.php on line 704
Warning: Undefined array key "online" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3548
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Undefined array key 111673 in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3534
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3536
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/user.php on line 704
Warning: Undefined array key "online" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3548
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Undefined array key 111673 in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3534
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3536
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/user.php on line 704
Warning: Undefined array key "online" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3548
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Undefined array key 111673 in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3534
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3536
Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/user.php on line 704
Warning: Undefined array key "online" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3548
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72
Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77
Warning: Undefined array key "birthday_search" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 173
Warning: Undefined array key "joindate" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 190
Warning: Undefined array key "posts" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 191
Warning: Undefined array key "posts" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 197
Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 6509
Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 212
Warning: Undefined array key "privacy_options" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 251
Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 4998
Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 1585
Warning: Undefined array key "lastactivity" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 1601
sql help, please -
MC Press Online Forums
ok ... i'm developing a report utilizing sql. i have some sum functions that i'm using. if i have these straight in the select clause everything works. as soon as i use them in a subselect or in the having clause it errors out. if anyone can tell me why this does not work, it would be greatly appreciated. the code and error message is in the code section below. does anyone know why i cannot use these sums in a subselect??? Code
quilaho wrote: > ok ... i'm developing a report utilizing sql. i have some sum > functions that i'm using. if i have these straight in the select > clause everything works. as soon as i use them in a subselect or in > the having clause it errors out. This error can be kind of tricky to solve at times but first: Are you sure the first statement is complete? I see no Group By clause and that should cause an error. First thing I would try on your second statement is to reverse the Having statement. Hopefully it will do the >0 check first if you specify it first. If that doesn't work, reply back and I'll give you another possibility at a solution using the "With" clause. Bill
Comment