stored procedure question

[JJ297]

Could someone please assist me...

I'm trying to get all records in the database that displayedques = 'y' and displayedques = null. This is my stored procedure but it's not returning what I want.

select QuesNAns.questions, QuesNAns.answer, QuesNans.displayedques, topics.topicid
from QuesNAns, topics
where QuesNAns.topicID = Topics.topicID
and displayedques = 'y' or
displayedques = 'isnull'(displayedques, '""')

Thanks in advance.

 

[gmmastros]

try this...

[COLOR=blue]select[/color] QuesNAns.questions, QuesNAns.answer, QuesNans.displayedques, topics.topicid
[COLOR=blue]from[/color]   QuesNAns
       [COLOR=blue]Inner[/color] [COLOR=blue]Join[/color] Topics
         [COLOR=blue]On[/color] QuesNAns.topicID = Topics.topicId
[COLOR=blue]where[/color]  (displayedques = [COLOR=red]'y'[/color] 
       or displayedques [COLOR=blue]Is[/color] Null)

-George

"the screen with the little boxes in the window." - Moron

 

[JJ297]

Thanks George it worked!