Querying On User Input

[dinobfc]

Help! Need help designing query

i am currently studying a-level it and need to do a query that will enable me to input the user id into the sale screen and then this will bring up the name that is stored in a seperate field. all of my teachers are crap and i need to do this. pleae Help!

 

[Mile-O]

In seperate tables? If so, you'll want to use an INNER JOIN.