ACCESS FEED: RE: [MS_AccessPros] Re: SQL Syntax Needed

Rabu, 08 Mei 2013

RE: [MS_AccessPros] Re: SQL Syntax Needed

Terry-

I don't see the UserID you mentioned in your original post in Table 2. Are
the Employee fields repeated in Table 2? What is the complete layout?

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 4:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: SQL Syntax Needed

Thanks for your reply, John. The table structure does indeed violate
normalization rules. It comes from a flat file data extract from a
relational database. The DB is normalized, but the export utility flattens
to the following layouts.
Table 1
Manager Position Number

Table 2
Manager Position Number
Employee Position Number
Employee Name
Employee ID

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> 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
>

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

Yahoo! Groups Links