Todd,
Try this:
select N.news_ID, G.group_ID, N.news_Title, G.group_Title
from news as N
inner join group_news as GN on N.news_ID = GN.newsID
inner join groups as G on GN.group_ID = G.group_ID
where G.group_ID = 25
order by N.news_Title
Hope it's not too late to save your brain. :-)
Tim
Hey Tim -
No, you weren't too late. I ended up calling it a night last night before I
could figure it out, hoping that a little sleep would help. Well, thanks to
you it did! I was close but needed one more join in there. I will have to
study yours and figure it out exactly, as I have a few