You really need to research join types for this. INNER JOIN, INNER LEFT,
OUTER RIGHT etc. There are a plethora of examples and options on the web.
Also, the DISTINCT keyword might help, as in "select DISTINCT department";
this would return only those departments in courses that have a
correspond
Alex,
> I have two tables in my database with a department name.
> One table (department), the name only appears once and it includes all
> departments in the school. In the other table, (courses) department can
> appear several times, but not all departments will be in the table.
>
> I used the f