Re: one on one joins

2004-06-23 Thread SGreen
You will have to use some criteria other than table position to delete just the "first" match in table 1. The concept of "first" and "last" only apply to ordered sets of data and there is _no_ guarantee that records entered sequentially will be _stored_ sequentially in the actual data structure.

one on one joins

2004-06-23 Thread [EMAIL PROTECTED]
Hi list, I have a problem concerning two tables. Basically, I need a strict "one on one join". Simplyfied, the problem is as follows: I need a check on two tables: T1: containing four records, with the value of field id being 1, 2, 3, 4 T2, same structure, containing the records 1, 2, 3, 5 f