ACCESS FEED: RE: [MS_AccessPros] SQL Syntax Needed

Selasa, 07 Mei 2013

RE: [MS_AccessPros] SQL Syntax Needed

Terry-

This is difficult to solve in SQL because it sounds like Table 2 has a
design problem. If I'm reading your description correctly, the multiple
position numbers in Table 2 is a repeating group that violates First Normal
Form in table design. Table 2 should look more like:

ManagerID
PositionID
EmployeeID

That gives you one row per employee and position for each manager, not
multiple columns.

Can you post the exact layout of the two tables?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Wednesday, May 08, 2013 1:34 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] SQL Syntax Needed

Hi,
I have two tables, table one (1) with rows that have a manager position
number column; the other table (2) has rows containing manager position and
the position numbers of employees that report to a manager, plus a user ID
column.
I'm trying to create a query that will result in a row(s) with the manager
position number from table (1), and the employee position number and user ID
in table (2) that have a manager position number in table (2) that matches a
manager position number in table (1).

Thanks for any suggestions.

------------------------------------

Yahoo! Groups Links