How to Create a Left Join View in SE11? + Explain Inner Join and Left Outer Join with Example

Question

How to create database view in SE11 with LEFT OUTER JOIN?

Original Question:

Can I create Search Help / VIEW with all the existing ICPNs + information about ORDER_ID from Ordered Items database table.

Required output:

ICPN

MODEL

STORE

PRICE

CURRENCY

ORDER ID

978-0997082302

SEDAN

BRATISLAVA

45.000,00

EUR

12

978-0997082303

SEDAN

BRATISLAVA

50.000,00

EUR

12

978-0997082304

SEDAN

PRAHA

1.250.000,00

CZK

 

978-0997082305

HATCHBACK

PRAHA

1.000.000,00

CZK

 

978-0997082306

HATCHBACK

BRATISLAVA

50.000,00

EUR

 

978-0997082307

HATCHBACK

BRATISLAVA

50.000,00

EUR

 

978-0997082308

HYBRID/EL

BRATISLAVA

51.000,00

EUR

 

978-0997082309

HYBRID/EL

BRATISLAVA

48.000,00

EUR

 

978-0997082310

HYBRID/EL

PRAHA

1.150.000,00

CZK

 

978-0997082311

HATCHBACK

PRAHA

60.000,00

CZK

 

978-0997082312

SEDAN

PRAHA

1.100.000,00

CZK

 

978-0997082313

SEDAN

PRAHA

1.200.000,00

CZK

 

Database Tables:

If I create a view which connects CAR and ORDERI tables:

.. output contains only ICPNs which were already ordered.

I miss here other car records.

How is it possible to create?

Comments

Add comment

Your email address will not be published. Required fields are marked *

 

Your personal information will be exclusively used for processing current comment only. Personal data protection policy