Relationship setting in SQL

hi,
i m having a database which contain more than 3 table. i lke to get the value form 3 table and make it as one table.

in first table using where condition i will pass two variable. it will filter and give a column call productID which has 3 row say productid filtered is 3,5,6 which is shown in a column.

with this productID i have to get the values in of productCode in another table. i will also give a column with more than i row.

finally i have to pass the productcode to the third table and get the following columns like productdecs, cost, availableplaces

this my situation. can u pls give this in a single query. so that i have to fill in datagrid.

bye
manoj