<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
My Db has two tables joined on ID.<br />
<br />
tblMasterName<br />
&nbsp; &nbsp;ID<br />
&nbsp; &nbsp;MasterName<br />
<br />
tblAlternateName<br />
&nbsp; &nbsp;ID<br />
&nbsp; &nbsp;AltNameA<br />
&nbsp; &nbsp;AltNameB<br />
&nbsp; &nbsp;AltNameC<br />
<br />
I would like to select * from tblMasterName so that a row contains MasterName, AltNameA, AltNameB, AltNameC.
</div>
</div>


Hi Experts,

My Db has two tables joined on ID.

tblMasterName
   ID
   MasterName

tblAlternateName
   ID
   AltNameA
   AltNameB
   AltNameC

I would like to select * from tblMasterName so that a row contains MasterName, AltNameA, AltNameB, AltNameC.

SQL query needed

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.