I need a help in writing a query which only select one record from the table . I have four tables , all linked to each other .
Accounts
acctno
303753
304759
303381
Customer
cusid first name lastname
1 abc cde
2 mad guy
3 miss uni
4 uni miss
consumer
consumerno cacctno
123456 303753
1234567 304759
customer role
acctno cus id
303753 1
303753 2
304759 3
303381 3
Expected Output Acct no cusid firstname lastname consumerno 303753 1 abc cde 123546 304759 3 miss uni 1234567
