[Resolved] Query 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'";

[nemonoman]

You must check your data
The results tell you that there are only 2 sets of records where all the joining elements line up.

You might be able to discover the missing elements by rewriting your query using "LEFT JOIN" instead of INNER JOIN.

[obrienkev]

Tried using "left join" but no differnece.

Basically the subfund table contains the foreign keys from client, director, manager, entity, etc, tables.

So with each row of data in subfund table is a client_ID, a entity_ID, manager_ID, etc.

So I want to select a client from client table and that is to bring up all matching results from the subfund row.

Then client_ID in client table matches a client_ID in a certain row in subfund table.

The other fields in that subfund row such as manager_ID, entity_ID, etc, should then connect with their primary keys and display entries in their respective tables.

Make sense??

So that's what I'm trying to do with my query.

Any ideas??