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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar