Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Need Help on a Select Statement for Access

Author  Topic  zzzzzz Starting Member 1 Post Posted - 2008-11-14 : 09:39:55 Hello all, In access, I have a table called Employee, a table called Loan and a table called Item. In the Employee table, I have 2 columns: Name and Appointment. In the Loan table, I have 3 columns: LoanNo., LoanedByName, and ItemLoaned. in the Item table, I have 2 columns: ItemNo. and ItemDescription. I am trying to write a Select statement, to choose an employee(LoanedByName) from the Loan table, by which it will display the items which the employee has loaned(everything from the Item table) and the LoanNo.. For example: I wish to select John, then the table will display: 0002(LoanNo.), 023(ItemNo aka ItemLoaned), Drill, Saw(ItemDescription). As the items are from a different tables, I can't seem to figure out how. Do I use inner join or something? Thanks in advance.