Shoutbox

Thanks, that sounds like that would do exactly what I need, except I'm not sure if I can use it.

I am using these SQL queries in a data transfer program that connects to an IBM server, and I don't full full SQL access, just some fields to fill in:

If I tick 'Enable group functions' then the 'Group By' and 'Having' fields become enable, but the 'Join By' is always disabled for some reason.

So using what you told me, I'm not sure if I can do it that way, any ideas?

EDIT:  I managed to do it another way, prob not very efficient or whatever, but it works .

code:

---

M1PNON IN (SELECT M1ON FROM M1P WHERE M1PNON IN (SELECT M1ON FROM M1P WHERE M1PNON LIKE '573.%'))

---

Thanks for the help