@ratbak hello, it's not postgres. it's called pervasive. There are no pervasive forums and since this DB engine uses SQL I figured it would be alright to post. most of...

@phil parkin this doesn't even run. no errors or anything it just will not execute

@kaj I get a syntax error

• This reply was modified 2 years, 6 months ago by  profoundhypnotic.

The sub -select gave me an Invalid row count in sub query error. I tried googling that error but it was all related to queries that are trying to count...