How would I write the following query in LLBLGen? (The WHERE clause is where I am having the issue) ** I am using LLBLGen 2.5.

SELECT * FROM XXXX WHERE (Column1 + column2 < {some value})

This is the complete query

SELECT COUNT(*) TripCount FROM Trip WHERE Location_Id = @LocationId AND Departure_On = @TourDate AND (Departure_Time BETWEEN @TourTime AND (@TourTime + (@TourDuration-1)) OR (Departure_Time + Trip_Duration >= @TourTime AND Departure_Time < @TourTime)) AND Schedule_Position = @SchedulePosition

Thanks

Hi Tri-Focus,

You can achieve that with Expressions in predicates. Here is an example: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16784&StartAtMessage=0&#93869

Hope helpful

Thanks, I will give is a shot. I appreciate the quick response to the question.