Hi there again,
How can i write this query in llblgen with resultsetfields
SELECT p.date,p.type,
CASE WHEN p.amount-pp.amount < 0 THEN 'NonOK' ELSE 'OK' END As [Status]FROM Payment p LEFT OUTER JOIN PaymentPlan pp ON p.planid = pp.id
The trciky part is the part written in bold
