Hi,
Has anyone seen this error after defining a data source?
All my other data sources use selects without joins just fine.
SQL
SELECT distinct ld.loan_id,
th.effective_due_date
FROM trans_hdr th
INNER JOIN vw_loan_data ld ON th.id=ld.hdr_id
INNER JOIN customer c ON th.customer_id=c.id
WHERE th.status_id in (1)
and th.loan_model_id = 459
and th.store_id = '171' order by rand() limit 1;