[Q] Data dictonary and recursion

I am building a dynamic form to maintain some tables. The SQL statement current works for tables that have 1 level of foreign key.

The problem:

Table A
  Column_a (key)
  description

Table B
  Column_a (key) (also foreign key)
  Column_b (key)
...

Table C

  Column_a (key) also foreign key to Table B
  Column_b (key) also foregin key to Table B
  Column_C (key)

I am having problems with the SQL statement to get the 'Table A' for column_a.

The script that I have now returns
Column Foreign_key_table

  Column_a    Table_b
  Column_b    Table_b
  Column_c

I want it to return

  Column_a    Table_a
  column_b    table_b
  Column_c

Any help would be much appreciated.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 16:19:57 CDT