[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.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

MARKETPLACE

---

---

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___