I have 2 table member table and voucher table. Member has many voucher, voucher has manay member For example Member A has voucher1, voucher2 Voucher1 has members memberA, membersB, memberC. Voucher2 has members memberA, memberC memberB has vouchers voucher1 MemberC has vouchers voucher1, voucher2, voucher3 Vocher3 has members memberC, memberD MemberD has voucher4 Voucher4 has members memberD
How create query to get all relation member has voucher from memberA to member D related by voucher
Jd querynba mendapatkan semua member dr relasi voucher. Dr root sampai akhir.
Input roor bs bebas sesuai input.
Lalu dicari semuai voucher yg di punyai dan dari seriap voucher yg dipunyai di cek semua member yg terkait voucher itu.lalu dari setiap voucher itu di cek semua member yg terkait vocuher itu, begitu seterusnya muter muter member voucher voucher member sampai akhir
Ada yg bisa membuatkan querynya? silahkan bid