Re: Barry Galbraith, here is some additional information

[Kurt Wayne]

Barry, almost there. (I'd post a link here to the output, in PHP as you said, but I'm not sure I'm supposed to.) 2 final questions:

1. The "radio" site same link is being repeated every row instead of being listed just once. (i.e. for one city there are six newspapers, 1 radio station...with six rows created for each newspaper, the same radio link is displaying on all six rows when I just want the one radio link to display once (in the first row)).

2. (And I know why this is happening...because we're joining on cities common to "brasil_newspapers" and "brasil_radio") There are a few cities in "Amapa" that don't have radio stations but do have newspaper sites. Any easy way to list those in a query like this?