[Resolved] Table Results Problem

[obrienkev]

Hi all,

The following query returns only two results out of possible 10.

Why is this??

$query="select *
from client as c
inner
join subfund as s
    on s.client_ID = c.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'";

[bradgrafelman]

Well, are you sure $client is set correctly? Without seeing the actual data in the tables, I can't really help you. Could be a SQL query problem, and I'm no expert w/ SQL. The folks in the "Database" forum would probably know more, but you can wait and see I spose.