<div>
and yet another variation (just for fun):<br />
<br />
select requestid,releasemonth,rel<wbr />easeyear,s<wbr />ubline<br />
into table4<br />
from <br />
&nbsp; table1 inner join table2 using(requestid)<br />
&nbsp; inner join table3 using(requestid)
</div>


and yet another variation (just for fun):

select requestid,releasemonth,releaseyear,subline
into table4
from
  table1 inner join table2 using(requestid)
  inner join table3 using(requestid)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to write a query that pulls information from three different tables, and joins the information from the three tables into one record.<br />
<br />
Each table has one field in common with the others. &nbsp;<br />
That field is RequestID.<br />
From table A I need to pull RequestID, LoadedLOE.<br />
From table B I need to pull RequestID, ReleaseMonth, ReleaseYear.<br />
From table C I need to pull RequestID, Subline.<br />
<br />
The query needs to combine these records into my table D.<br />
<br />
Thanks in advance for your time.
</div>
</div>


Hi,

I need to write a query that pulls information from three different tables, and joins the information from the three tables into one record.

Each table has one field in common with the others.  
That field is RequestID.
From table A I need to pull RequestID, LoadedLOE.
From table B I need to pull RequestID, ReleaseMonth, ReleaseYear.
From table C I need to pull RequestID, Subline.

The query needs to combine these records into my table D.

Thanks in advance for your time.

Need an example of a query of how to pull record data from three tables?

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.