?
Solved

SQL query needed

Posted on 2011-09-08
1
Medium Priority
?
168 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:DColin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 36504916



select tblMasterName.MasterName,  tblAlternateName.AltNameA, tblAlternateName.AltNameB, tblAlternateName.AltNameC
From   tblMasterName inner join tblAlternateName On tblMasterName.ID=tblAlternateName.ID
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question