topic Re: Selecting fields in Application Development and Automation Discussions

Selecting fields

Former Member — Sat, 10 Mar 2007 13:25:03 GMT

Hi all,

I have three tables.

Tab1 with two fields AccountNumber and Description

Tab2 with GLAccntNumber and some fields

Tab3 with CLAccntNumber and some fields

Both GLAccntNumber and CLAccntNumber have values from AccountNumber.

Now, I need a Database view which contains fields as below:

GLAccntNumber Description CLAccntNumber Description

How can i achieve this?

Example:

Tab1:

111 Description1

222 Description2

333 Description3

444 Description4

555 Description5

Tab2:

111

333

444

Tab3:

333

555

Thanks in advance.

Re: Selecting fields

Former Member — Sat, 10 Mar 2007 15:48:01 GMT

In SE11 you can create database views by selecting "View" option. Once inside specify your tables and join condition and select fields to be contained in the view from the two tables.

Re: Selecting fields

Former Member — Sat, 10 Mar 2007 16:56:09 GMT

Go to SE11 .. there u check the field VIEW .. and give a name for this view and click on the CREATE button... Here u need to define the field names ... and mention the join conditions on the fields u want ( from the three fields )...

reward if it helps u ....

sai ramesh