get only unique ids 1

[RobBroekhuis]

I'm sure this is simple, but I'm new to SQL, especially to queries involving more than one table. I have the following query:

select threads.threadid from posts,threads where posts.threadid=threads.threadid and (text like '%quote%' or subject like '%quote%') order by threadid desc

where threadid is the primary key for table threads, and any threadid can occur one or more times in posts. text is a field in posts, subject is a field in threads. How do I modify this query so that each threadid is only returned once?


Rob

 

[sleipnir214]

Use the DISTINCT keyword:

SELECT DISTINCT(threads.threadid) FROM.....

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[RobBroekhuis]

Works fine. You came through for me again. Thanks!

Rob