Help!
The following query returns two different result sets based on where it's run!
When I run this query from the green screen STRSQL program, I get no records. When I run it from the Run SQL Scripts function from iSeries Navigator, I get the 116 records I would expect to see.
(F.R.O.G. returns no records either. I guess that MUST be the right answer! )
WHY?!?!?!?!
Michael
The following query returns two different result sets based on where it's run!
Code:
Select ClsDte, SubNam, Job#, Addrs, Street, Purch, cssls#, csbld#, csccr#, csdcc#, csq1a, csq1b, csq1c, csq1d, csq1e, csq1f, csq1g, csq1h, csq1i, csq1j, csq2a, csq2b, csq2c, csq2d, csq2e, csq2f, csq3, csq4, csq5 From TST#FILE.JOBMST a inner join tst#file.subdvn b on a.subdiv=b.subdiv inner join tst#file.CSSRVY c on a.subdiv=c.cssub and a.job#=c.csjob# Where char(date(csupstmp)) between '2007-06-01' and '2007-09-30' Order by ClsDte, SubNam, Street, Addrs
(F.R.O.G. returns no records either. I guess that MUST be the right answer! )
WHY?!?!?!?!
Michael
Comment