Newbie Inner Join Help

[Lost in Microbiology]

Hi All,

I have a table with 4 fields. The PK is an auto-number, lastname, firstname
and JournalID.

A person's name can be entered multiple times (might not actually be the
same person, just the same name, i.e John Smith). The JournalID may have
between 1 and 13 names associated. I want to combine all authors into one
table based on the JournalID so I can search by an author name and find how
many JournalID's there are. I think I am looking to do an inner join, but am
having a problem conceptually. I am looking to Select lastname and firstname
where JournalID is the same, and put them into another table...correct? Any
guidance, or a link that explains the clearly would be greatly appreciated.

 

[Steve Schapel]

Lost,

No, you don't want to put them into another table. You want them to be
returned by a correctly designed query.

And no, you don't want an Inner Join, as this implies a Join between 2
tables, and so far you have only mentioned one table.

Having said that, I am still unclear about what you want. But try this...
Simply make a query based on your table, add all 3 fields to the query
design grid, and in the Criteria of the JournalID field, enter the ID of one
of the journals. Run the query (click the red [!] button in the toolbar).
You will see the names of all the people associated with the selected
journal. Does that give you any clues where you can go with it?