Forum Post: Query On Many To Many Relationschips

  • Thread starter Thread starter Wim
  • Start date Start date
Status
Not open for further replies.
W

Wim

Guest
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?

Continue reading...
 
Status
Not open for further replies.
Back
Top