Re: [SQL] Related tables to a view

2006-12-25 Thread Michael Fuhr
On Mon, Dec 25, 2006 at 10:52:03PM +0100, Jan Meyland Andersen wrote: > If I have a view which is a selection from field1 and field2 from table1 > and field1 and field2 from table2. > > How can I make a selection which returns the relation for the fields in a > way so I am able to se which field b

[SQL] Related tables to a view

2006-12-25 Thread Jan Meyland Andersen
Hi I need a function which are able to return the underlying tables to a view. If I have a view which is a selection from field1 and field2 from table1 and field1 and field2 from table2. How can I make a selection which returns the relation for the fields in a way so I am able to se which field