Help with querie and sql

L

lynn

I have a form based on a query. For some reason not all
the records show when the query is run therefore do not
display on the form. The record does however exist in the
employeedetails table. Can anyone explain why this might
be happening. the querie SQL is as follows

SELECT employeedetails.*, [post details].*,
selection.action
FROM (employeedetails LEFT JOIN [post details] ON
employeedetails.[post ID] = [post details].[post ID]) LEFT
JOIN selection ON employeedetails.[employee ID new] =
selection.[employee ID];

I cannot see any difference between the records which show
and the records which dont. eg no records have been linked
to a post as yet, nor does either have a link to the
selection table. In fact, I imported 20 records all with
just names and addresses to the employeedetils table, but
only some of these show in the query - I cannot see the
difference. I need all employee details to show whether
they have a current post or selection record.

What have I done wrong?
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top