goaliebob99
New Member
This board is fantastic, and hopefully one of you guys will be able to help a not-so-savvy beginner to ASP like myself. <BR><BR>Here's the deal. I want to create a database that keeps track of all the calls a particular agent takes in the call centre I work for and also breaks down the call types. <BR>I've created the DB in Access and it contains two tables<BR><BR>1)tblAgents<BR>2)tblDay<BR><BR><BR>the agent Id number in tblAgents is the primary key and has a one-to-many relationship with tblDay.<BR><BR>What I'd like to do through an sql query is pull a couple of fields from both tables. For example, pull the agent's name field in from tblAgent, and whatever date selected from tblDay, and so on and so forth. I was told one way to do this would be ab "inner join." <BR><BR>Can someone give me some help with how this would work given my scenario?<BR>UPDATE: I think I've got it figured out.......for now 
Try the Database Q&A forum instead...
Try the Database Q&A forum instead...