I have this query, which select fields from 2 tables
SELECT D.debtor_id,D.fname,D.lname,M.lastDate,M.WeeksDue FROM debtor_information D,debtor_money M WHERE D.creditor_id='457456' AND M.creditor_id='457456';
you can see a demo here and hopefully contribute to this fiddle. http://sqlfiddle.com/#!2/c264a/2
I want only 1 debtor_id for each debtor.