Query on many to many relationschips

Hello,

Im a trying to do a query in an n to n relationship using:

v_result = rbv_api.selectQuery2("SELECT discounta_sellpercentage, R_discount_tyrelabel,R_discount_rimdiameter FROM discount " +
"WHERE R_discount_condition = ?" +
"AND R_discount_customers = ? " +
"AND R_discount_isocountry = ? " +
"AND R_discount_pricecategory = ? " +
"AND R_discount_rategroup = ? " +
"AND R_discount_contracttype = ? " +
"AND R_discount_application = ? " +
"AND R_discount_applicationtask = ? " +
"AND R_discount_tyrelabel IN (SELECT id FROM tyrelabel where R_tyrelabel_discount = ?) " +
"AND R_discount_seasonappliance = ?" +
"AND R_discount_tyrebrand = ?" +
"AND R_discount_tyretotransporttype = ?" +
"AND R_discount_rimdiameter = ?", 0, 10, v_conditionid, v_customerid, v_isocountryid, v_pricecategoryid, v_rategroupid, v_contracttypeid, v_applicationid, v_applicationtaskid, v_tyrelabelid, v_seasonid, v_tyrebrandid, v_transporttypeid, v_rimdiameterid);

The IN (SELECT gives an error. 

Can anyone help?