	
	Does the SQL(99?) spec specify that referential integrity checks should have the FROM ONLY limitation? I ask because(afiak; I've googled and such, only found 92 which apparently does not specify anything about inheritance.) I have no access to the specs without spending money that needs to go other places..

	I have a hierarchy of tables that reference base tables that may never have insertions, but its children do, which of course creates the problem of "broken" referential integrity checks due to FROM ONLY.

	Of course I know I can edit the source, but I figured I'd see if this is specified in the spec, and hopefully induce a change if it isn't.


Thanks for you time,

James

btw, I'm not on the list(yet, perhaps), so please CC me.


Sat, 7 Jun 2003 11:17:03 -0700
James Pye <jwp@rhid.com>
FROM ONLY limitation in RICs