Skip to Content
Sep 08, 2009 at 07:09 PM

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.