Two Joins to Single Table

[hml398]

I need to be able to join two fields in table a with a single field in table b. I have chapterid and regionid in table a. I need to get the name of the region and the name of the chapter from the query based on the id values in table a. The problem is the structure of table b has regionid, regionname, ischapter fields instead of having a separate table for chapters. So I need to figure out a way to join chapterid in table a with regionid in table b AND regionid in table a with regionid in table b at the same time since I need it for each record. I have tried a bunch of things without success. Any ideas?

TIA
Heather

[The_ScareCrow]

Assuming ischapter indicates if the record is a chapter or not

Select *
From tablea a, tableb b
Where a.regionid = b.regionid
or (b.regionid = a.chapterid and b.ischapter = true)

Ken