> the ultimate++ solution just works for very very simple statements it works for every query. You can write for example: Select(PRODUCTS[ID], CUSTOMER[NAME]) .From(PRODUCTS) .InnerJoin(CUSTOMERS) .On(CUSTOMERS[PRODUCT_ID] == PRODUCTS[ID] && Like(PRODUCTS[NAME], "BOOK%")) .Where(PRODUCTS[ID] > 10); You can have another statement in where or even in select..