Must be missing something
Am I asking for something wrong here.....
what I want to do is display a list of available advisors.
SELECT advisors.name FROM advisors WHERE advisors.advisor_id = (SELECT available.advisor_id FROM available WHERE available.status = yes))
It should return simply an advisors name.
Thx, it's late in the day and I'm tired....lol
SELECT DISTINCT advisors.name FROM advisors WHERE advisors.advisor_id IN (SELECT available.advisor_id FROM available WHERE available.status = yes)
Last edited by chrismartz; 01-10-2006 at 07:50 PM.
Thanks Chris, works a treat!
...the cats spins around and licks the butter off the toast
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?
No problem. Just remember that if you have a list of items your selecting from, use IN instead of =.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)