VS 2008 Using Variables / Parameters In Sql Queries?

I am using Visual Basic 2008 / MYSQL

Basically i have 2 tables in mysql called Data and products

The first sql query i want to do is something like this to scroll through the recordset of products and bring back information;

dbquery.commandtext = "select quantity, sku, condition from products"

But then what i want to do is bring back information from the Data table based on the sku and condition of the first sql?

so it would be something like this

subquery.commandtext = "select lowestprice from data where sku = *SKU FROM FIRST TABLE* and condition = *CONDITIONFROM FIRST TABLE*"