I'm trying to write criteria to pull data from 2 tables. EMPLOYEE and EMPCODES. If I write a SQL query from these tables I get 2 results, but when I build the same query in IPD it returns 3 results. I'm trying to figure out how to set the group criteria so query would be: all Codes where Date_Returned="today" or systemdate. right now it looks like this: SELECT=COMPANY=1000%26DATE-RETURNED=<!SystemDate>%26CODE=REFERRAL2|CODE=SIGNON1|CODE=SIGNON2 but I need it to look at only Codes that have a Date_Returned of today and not any Code.
Can anyone tell me how to group this in the builder or in the query itself?
