Solved

SQL query needed

Posted on 2011-09-08
1
161 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
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

773 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