Append Data from two tables

[BioHazard]

Hi Folks,

I spend now more time than I would like with this trouble:

I would like to append a number of data from two tables to a third one. From table1 the primary key field should be selected as maximum entry. From table2 the primary key field should be assigned as group.



Before trying in append mode I tested the query in selection mode:

This results in tuples of all entries from table2 together with the maximum entry from table1. Both tables also contain identical fields (which represent foreign keys to a third - different - table). When relating these fields in the query, the number of tuples get reduced to all entries relating to the specific field in table2, which actually should be fine.

Unless, no tuple should be expected, since the maximum entry primary key from table1 does not appear in table2 with the associated foreign key!!!

I'm more than confident that the reason for this problem is presumably of simple nature.

Can anyone help? Thanks in advance!

[NTC]

I am not able to understand your post. A primary key field will never have duplicates, thus one would not apply an aggregate maximum method to it - as that would only result in the 1 highest value. So it is not clear what field is being found as a maximum.

But in any case once you have isolated the correct record set of Table 1 using Query 1 ; then joining Query 1 to table 2 would of course result in all records of table 2 that have a matching key value. Whether or not there are duplicates (tuples?) depends on whether they exist as duplicates in table 2