SQL Query Help

[Former Member]

Hello All,

I am quite an experienced consultant, but for the love of god I can't figure this out...

I have this query

select a_{vbeln b}vbeln c_{vbeln d}vbeln into table gt_output

from vbak as a "master contract

join vbak as b "inquiry

on b_{vgbel = a}vbeln

join vbak as c "quotation

on c_{vgbel = b}vbeln

join vbak as d "debit memo

on d_{vgbel = c}vbeln

WHERE a~vbeln in s_mc

and b~vbeln in s_inq

and c~vbeln in s_quo

and d~vbeln in s_deb

and a~trvog eq '4'.

Now table C has 23 entries so I would assume that my internal table will have 23 lines. I know table a, b and d bring back one entry... And the output right now is 1 line... How can I rectify this without splitting the query into several for all entries (because the selection screen has 4 options and anyone of them can be chosen or not)

Note that there are 4 different doc types, and each one is related vgbel = vbeln so i know my query is semi-right as the 1 line it brings back is correct, just there should be more lines!!

Thanks in advance.

[former_member156446]

did you try outer join?

[Former Member]

done