Selecting fields

[Former Member]

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.

[Former Member]

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.

[Former Member]

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