find tablename, attributvalue given

[Christian Höhener]

Hi

I have a given attributvalue of a specific attribut (sys_obid=81653) which
occurs in multiple tables. Now, I should know the tablename of the table in
which this attribut occurs.

Which possiblities do I have to find it out?

-> "find tablename where sys_obid=81653 ....?"

Thanks a lot.

Christian

[John]

Hi, Christian:

Normally, you'd want to find the rows in specific tables which contain a
certain value. What is it you want to get out of your query?

ie. let's pretend you want a customer id. You can select from the
CUSTOMER table where the customerid = 55.

Say you want to show all the orders where the customerid is 55. Select
from the ORDERS table where customerid = 55.

If you also wanted to show the person's name next to each order record,
you would do a table join. For example:

SELECT ORDERS.ORDERID, CUSTOMER.NAME FROM ORDERS JOIN CUSTOMERS ON
(ORDERS.CUSTOMERID = CUSTOMER.CUSTOMERID)
WHERE ORDERS.CUSTOMERID = 55
ORDER BY ORDERID;
Hope that helps a little,
John
Christian Höhener wrote:

Hi

I have a given attributvalue of a specific attribut (sys_obid=81653) which
occurs in multiple tables. Now, I should know the tablename of the table in
which this attribut occurs.

Which possiblities do I have to find it out?

-> "find tablename where sys_obid=81653 ....?"

Thanks a lot.

Christian

[John]

Hi, Christian:

Normally, you'd want to find the rows in specific tables which contain a
certain value. What is it you want to get out of your query?

ie. let's pretend you want a customer id. You can select from the
CUSTOMER table where the customerid = 55.

Say you want to show all the orders where the customerid is 55. Select
from the ORDERS table where customerid = 55.

If you also wanted to show the person's name next to each order record,
you would do a table join. For example:

SELECT ORDERS.ORDERID, CUSTOMER.NAME FROM ORDERS JOIN CUSTOMERS ON
(ORDERS.CUSTOMERID = CUSTOMER.CUSTOMERID)
WHERE ORDERS.CUSTOMERID = 55
ORDER BY ORDERID;
Hope that helps a little,
John
Christian Höhener wrote:

Hi

I have a given attributvalue of a specific attribut (sys_obid=81653) which
occurs in multiple tables. Now, I should know the tablename of the table in
which this attribut occurs.

Which possiblities do I have to find it out?

-> "find tablename where sys_obid=81653 ....?"

Thanks a lot.

Christian