Must be missing something

[CrazyMerlin]

Am I asking for something wrong here.....


SELECT advisors.name FROM advisors WHERE advisors.advisor_id = (SELECT available.advisor_id FROM available WHERE available.status = yes))


what I want to do is display a list of available advisors.

It should return simply an advisors name.

Thx, it's late in the day and I'm tired....lol

[chrismartz]

try
SELECT DISTINCT advisors.name FROM advisors WHERE advisors.advisor_id IN (SELECT available.advisor_id FROM available WHERE available.status = yes)

[CrazyMerlin]

Thanks Chris, works a treat!

If toast always lands butter-side down, and cats always land on their feet, what happens if you strap toast on the back of a cat and drop it?

...the cats spins around and licks the butter off the toast

[chrismartz]

No problem. Just remember that if you have a list of items your selecting from, use IN instead of =.