Inheritance and origin of rows
Inheritance and origin of rows
От:
joerg.troester@gmx.net
Дата:
In my database I created a table "partners" and two tables "individuals" and "companies" which are inherited from "partners". Table "partners" has columns "name", "address", "phone",... Now I want to query any partner being an individual or company by a statement like "select name,address,phone from partners*". For further proceeding the information is needed which table (individuals or companies) any row is taken from. My question is: * is there any possibility to retrieve this information from a system table (e.g. the name of the table where a row/rowid resides in) * or do I need a workaround like adding a column "tablename" into table "partners"? Thanks a lot for answering. --- Sent through Global Message Exchange - http://www.gmx.net