Simple SQL Query Help

[aatrv]

I'm attaching a simple database to this post. I'm still a rookie at Access and I'm trying to figure out something simple. Basically, I have 2 tables: tbl_allusers and tbl_impusers. tbl_allusers has all the users registered in the system and tbl_impusers only shows the users that are important at the moment. I want to create a query so that when I run it, it filters the tbl_allusers and only pulls up records for the important users. I just want records for the imporant users, not all users. I believe I have to use an inner join, not sure exactly how to do it. Can someone please help? thanks!

 

[aatrv]

oops...forgot to attach the database lol here it is

 

[John Big Booty]

Create a query and select both your tables. Get rid of the Show Tables dialogue box. Now Click on ID in one of your tables and drag it across to ID in the other table. The end result should look like;

 

[aatrv]

I tried that..it doesn't seem to work :/ there's an error that comes up saying: "Query must have atleast one destination field"

 

[jdraw]

Yes, you have not selected any output. Identify the field(s) you want to display.

 

[aatrv]

wow that was stupid of me to ask that lol I should've known that... but yes it works perfect now, Thanks guys!