incremental file

kasturi

• August 09, 2011 00:00

• Answered

Follow

Hello Agata,
Incremental key is working fine for most of my graphs with the exception of one scenario.
I am getting this error
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

when I try to use the incremental key in this sql

SELECT lower(trim(a.email)) as email,MIN(o.order_date) AS order_date,max(address_id) FROM
address a,
order_header o,
payment p
where
a.address_id>#key01 and
lower(trim(a.email)) is not null and
p.billing_address_id=a.address_id AND
p.payment_id=o.payment_id
group by lower(trim(a.email))


Thanks and best regards,
Kasturi

• 

  ikulman

  • August 11, 2011 07:18

  0

  Comment actions Permalink

  Hello, the error message you stated is a database error message so I think your problem is in your sql query / database. Try running your query with a sample #key1 value in your database to see if you get the same error message.

Please sign in to leave a comment.