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.