I want to create a SQL statement that: finds the ID number of my item that is determined by user input that is compared against a user name. This is all done in one table. The second table i want to be able to use the id number of the first table that was found to search the second table to match up against an ID number. How is this done? Thx for your help.