Selecting columns from different tables
<p>I need to display two columns from my attendance table (MEMBER_ID &amp; MEETING_ID) and one column from my meeting table and finally two columns from my member table which displays the names that match with MEETING_ID. </p>

<p>The attendance table has a composite key (MEMBER_ID*, MEETING_ID*)</p>

<p>The member table's primary key is MEMBER_ID</p>

<p>Meeting table's primary key is MEETING_ID</p>

<p>My attempt is not working, can someone please help?</p>

<pre><code>SELECT MEMBER_ID, MEETING_ID, MEETING_NAME MEMBER_FIRSTNAME, MEMBER_LASTNAME
FROM ATTENDANCE, MEMBER, MEETING
WHERE MEETING.MEMBER_ID = MEETING.MEMBER_ID;
</code></pre>

<p>End result needs to be:</p>

<pre><code>MEMBER_ID    MEETING_ID   MEETING_NAME     FIRSTNAME    LASTNAME
0001         MEET0004     SPORTS DAY      JOHN         SMITH
</code></pre>