Skip to Content

Help in creating View

Hi Guys,

I am trying to create a view from table A and table B. Data in table A and table B are as follows.

Table A						TableB

Field_1  	Field_2				Field_1 		Desc_1
A1		B1				A1		New York	
A1		B1				A2		Albany
A1		B2				A3		Rochester	
A1		B2				A4		Buffalo
A1		B2				A5		Syracuse
A2		B1						
A2		B2

I want to get the following result:

Field_1   	Desc_1		Field_2	
A1		New York	B1				
A1		New York	B1				
A1		New York	B2					
A1		New York	B2				
A1		New York	B2				
A2		Albany		B1						
A2		Albany		B2

Please advise me which type of view should I create. I create Maintenance view and I am getting following error"

"No database view exists for view Z_TEST_VIEW".

Please help in creating a view without the error.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 08, 2009 at 08:59 PM

    Since your requirement is to view logically connected data from different tables, try creating the "database view".

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.