iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi,I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works)SELECT...
View Answer
| May 30 2008 2:31 PM GMT
| asked by
MarcGreen
DB2/400, SQL Query, SQL Subselect
How to use subselect in a case statement
Getting error... "Token EXISTS was not valid...." on case statement...,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#
View Answer
| Jan 17 2008 3:11 PM GMT
| asked by
Qpgmr
SQL, SQL Subselect, CASE statement
