Thread: inheritance and selection

inheritance and selection

From
"Francois TETE"
Date:
Hello,
 
I am wondering if there is a means to know to which table a row that I have selected actually belongs :
 
I have a base class (for example BASE) which I have derived (for example DERIVED1 and DERIVED2) and
I am performing the following request : 
SELECT * FROM BASE* WHERE <where clause>; 
and I would like to know to which table (i.e. DERIVED1 or DERIVED2) the selected rows actually belong.
 
Thank you for any help
 
Francois
---
Francois TETE
StreamCORE
2 place des Hauts Tilliers - 92632 Gennevilliers Cedex - France
  Mail : francois.tete@stream-core.com
  Phone: +33 1 41 21 46 22
  Fax  : +33 1 41 21 46 27