Query - no Data from two tables will be displayed

[daywalker0086]

Hi Users,
I have a problem with a query.
i have two tables with data.
In one table there are some articles with an unique ID.
in the other table there are some orders. every order held one article. In the order table the is one field were i write the 'Artikelnummer_Kunde' of the article.



My query have to display all the other fields of article wich is connected over the ID with the order.

But my query is empty. Where is the problem?





Kind regards
Christian

[lfpm062010]

You are join two table using field "Artikelnummer_Kunde" on both table.

The table "Fertigungsauftrage" has field "Kunde" and "Artikelnummer_Kunde" and table "Artlikelliste" only has field "Artikelnummer_Kunde".

Since the join field is "Artikelnummer_Kunde" and if both table does not have the same information. Then you are not going to get any data back.

For example,