Hi Keith,
No, I think I couldn't explain correctly.
For example:
Table_A Table_B
ID ID_Kind
Name Kind
ID_Kind
In some cases, I want to accept a new record in Table_A just if the ID_Kind is already in Table_B.
In other cases, I want to accept a new record in Table_A if ID_Kind is NULL or ID_Kind exists in Table_B.
The first example, I called "1..n" and the second "1-0..n".
[]s!
>>Hi.
>>
>>I bought xCase last month just for help me, and I want to know if SQL Server can undestand the difference between a 1-0..n relation and 1..n relation.
>>
>>I added both conditions in xCase but the SQL script has the same sintax.
>>
>>TIA!
>
>Rudolfo,
>
>In SQL Server, the difference between one to many and one to zero..many is in the select query, not the table definition (INNER JOIN versus LEFT|RIGHT JOIN).
>
>Did I understand your question correctly?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte