shanetastic Posted September 24, 2011 Share Posted September 24, 2011 I know this is basic, but I cannot figure it out. Here are my tables: Rep ----------- RepID (PK) RepName RepURL Company ----------- CompanyID (PK) CompanyName CompanyURL CompanyDescription States ----------- StateID (PK) StateAbbreviation StateName Territory ---------- RepID (PK) CompanyID (PK)* SateID (PK)* *these two columns will be made into a unique index. I would like a query that searches the Territories table and returns States.StateAbbreviation and Company.CompanyName for a given RepName. So is the RepName = "Rep1", the query should look in the Reps table and get the corresponding RepID. Then it should return all of the rows in Territories that match that RepID. Except I would like it to look at the States and Company tables so to return the StateAbbrevation and CompanyName rather than the IDs that are used in the Territories table. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 24, 2011 Share Posted September 24, 2011 Did you try writing a JOIN? Quote Link to comment Share on other sites More sharing options...
shanetastic Posted September 24, 2011 Author Share Posted September 24, 2011 Yes, I had tried several attempts at JOINs, but I was missing the "ON" statement. Now that I have that piece of the puzzle it is working perfectly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.