I am trying to find all of the rows of information in a table that match criteria of another table wtih one parameter being fed. What is the syntax for that.

Question

I have two tables, table 1with the data that I am trying to retrieve multiple rows and multiple columns of data from, and the other with ID's of records that I am wanting the data from in table 1.

I know that I use InnerJoin, but it isn't working for me. Here is what I have.

SELECT * FROM Table1 INNER JOIN Table2 on Table1.* where Table2.ID = @ID"

@ID is a session variable I am feeding that containes the id I am looking for all the records of in table 2.

Thanks

---

DCSSR