Hi again,

Another question about a query. We made a query based on several different tables. This to show from every person in our database the connected data from these tables.

The problem is now that if we have no data from a person in a table, the person and his connected data from the other tables, will not occur in the query.

We think we have to use a Null value somewhere, but don't know how. Or that we have to change some settings in the query. Maybe someone can help us here?

Tnx a lot!

AB

hey there.. you have several SQL problems ;)..

anyway, you want to try left or right joins.. the only problem with that is how to structure the joins to always show your data...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo again!

Thanx a lot! We've worked this out.

Grtz,
AB