Why does this return nothing even when my database is populated?
$query="select *
from dummy as dy
inner
join subfund as s
on dy.dummy_ID = s.dummy_ID
inner
join accounting as a
on s.accounting_ID = a.accounting_ID
inner
join ta as ta
on s.ta_ID = ta.ta_ID
inner
join trustee as t
on s.trustee_ID = t.trustee_ID
inner
join mid_office as md
on s.mid_office_ID = md.mid_office_ID
inner
join strategy as st
on s.strategy_ID = st.strategy_ID
inner
join director as d
on s.director_ID = d.director_ID
inner
join client as c
on s.client_ID = c.client_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
inner
join nav as nv
on s.nav_ID = nv.nav_ID
where dy.dummy = '$dummy'";
Thanks,
Kevin.
