Help with simple JOIN

Hi, I'm having some real problems figuring out a seemingly simple join statement. I've looked through some of the mailing list posts, but I can't seem to find what I'm looking for. Here's what I have - 2 tables: table1 (id, stimulus_number, stimulus_type) table 2 (id, stimulus_number, stimulus_

Help with JOIN, please!

Hi, I'm having some real problems figuring out a seemingly simple join statement. I've looked through some of the mailing list posts, but I can't seem to find what I'm looking for. Here's what I have - 2 tables: table1 (id, stimulus_number, stimulus_type) table 2 (id, stimulus_number, stimulus_