Displaying array in "(x, y, z)" format to use in query

[kev510]

Hello everyone!

I've searched everywhere for an answer to my question with no luck. I've never used an array (yes I am a newb) before.

What I'm trying to do is to get a set of data --> select X, Y, Z from Table where number = 1

Which will always return one row and and obviously three columns, into an array called "XYZArray", so I can use it in another query like this --> select Supervisor from Table2 where number not in (insert the XYZArray array here)

Thanks for any help! Happy holiday season everyone

 

[PHV]

Why using an array ?
SELECT Supervisor FROM Table2
WHERE number NOT IN(SELECT X FROM Table WHERE number = 1)
AND number NOT IN(SELECT Y FROM Table WHERE number = 1
AND number NOT IN(SELECT Z FROM Table WHERE number = 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kev510]

goodness, i feel extremely stupid now.

Thank you so much for your help!

PS: If I ever did need to put it in (x,y,z) format, how would it be done? Is it goign to be a complicated step, like programming to add commas between each value, and parenthesis?

Thanks once again.

-Kev