How do I fix this so that subfund will be my main table??
$query="select *
from client as c
inner
join subfund as s
on c.client_ID = s.client_ID
inner
join director as d
on s.director_ID = d.director_ID
inner
join entity as e
on s.entity_ID = e.entity_ID
inner
join contact as co
on s.contact_ID = co.contact_ID
inner
join manager as m
on s.manager_ID = m.manager_ID
inner
join domicile as dm
on s.domicile_ID = dm.domicile_ID
where c.client = '$client'";
