Very Computer

I sure could use some help from the "SQL experts"!!   I've been trying to
run
the following query and get nothing but correllation errors.   I'm trying
to
display the Site Names which are linked to each Program Name using a
many-to-
many relationship table (SITE_TO_PGM).

SELECT   PROGRAMS.PROGRAM_NAME,    SITES.SITE_NAME

FROM     PROGRAMS,   SITES,     SITE_TO_PGM

WHERE    SITES.SITE_ID = SITES_TO_PGM.SITE.ID
         AND SITES_TO_PGM.PROGRAM_ID = PROGRAMS.PROGRAM_ID

Expected Output:

PROGRAM NAME 1  
   SITE NAME 1
   SITE NAME 2
   SITE NAME 3

PROGRAM NAME 2
   SITE NAME 4
   SITE NAME 5

Can someone please help me out?

---
Do I need a KEY JOIN?  I've tried this:

SELECT   PROGRAM_NAME,   SITE_NAME

FROM     PROGRAMS
         KEY JOIN SITES
         KEY JOIN SITE_TO_PGM

but get "NO WAY TO JOIN SITES to PROGRAMS"

---

Here's my 3 tables.  * = Primary Key

SITES Table            
===========                            

SITE_ID*        SITE_NAME
-------         ---------                                      
1               Site Name 1
2               Site Name 2
3               Site Name 3
4               Site Name 4
5               Site Name 5

SITE_TO_PGM Table
=================
SITE_ID*        PROGRAM_ID*
-------         ----------
1               1
2               1
3               1
4               2
5               2

PROGRAMS Table
==============
PROGRAM_ID*     PROGRAM_NAME
----------              ------------
1                       Program Name 1
2                       Program Name 2
3                       Program Name 3
4                       Program Name 4

Thanks...

Steve

Jasper