dbmanalser84
Registered User.
- Local time
- Today, 08:52
- Joined
- Feb 26, 2008
- Messages
- 52
Where can you best see the application of LEFT and RIGHT JOIN while Refferential Integrity is on in the relationship between the two tables?
I can clearly see this while Referential Integrity is not applied, because in that case it is allowed for data from one table not to have their counterparts in other table, so you can clearly see when you apply any JOIN type (LEFT or RIGHT).
When Referential Integrity is on all data from one table must have their counbterparts in other table, so how can LEFT or RIGHT JOIN (when applied) can be seen there, when that situation resembles of INNER JOIN?
While the option CASCADE DELETE (and Referential Integrity) is turned on, will the way of deleting records be changed in any of the two tables when you change the way of JOIN between them?
I can clearly see this while Referential Integrity is not applied, because in that case it is allowed for data from one table not to have their counterparts in other table, so you can clearly see when you apply any JOIN type (LEFT or RIGHT).
When Referential Integrity is on all data from one table must have their counbterparts in other table, so how can LEFT or RIGHT JOIN (when applied) can be seen there, when that situation resembles of INNER JOIN?
While the option CASCADE DELETE (and Referential Integrity) is turned on, will the way of deleting records be changed in any of the two tables when you change the way of JOIN between them?