Search results

I've been having a play and have so far been unable to recreate the situation in a new mockup database... guess I'll just have to keep chipping away at it for now!

I know if you do it as part of the WHERE clause using in then you can only return one field, I thought what I have was ok though. I might be wrong, it's been a while since I last played with a database and that was Informix.

Unfortunately it's sensitive data, I'll try and create the same issue using random data today if I get the chance! Thanks

Hi guys, I've got a problem that's driving me nuts and have no idea of what's going on. Essentially I've got a query which in the select clause includes a sub query which gets customer_ids with the earliest associated datetime, this is because each customer can have several entries and I am...