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