Question

EKKO EKPO EKET LIKP LIPS 这几张表如何关联？

Answer 1

select * from ekko
join ekpo on ekko~ebeln = ekpo~ebeln
join eket on ekpo~ebeln = eket~ebeln and ekpo~ponsr = eket~posnr
join lips on ekpo~ebeln = lips~vgbel and ekpo~ponsr = lips~vgpos
join likp on lips~vbeln = likp~vbeln
into table

追问

LIPS这张表如果不连呢 ？可以把LIKP也和EKKO EKPO EKET连到一起吗？连了LIPS速度很慢？谢谢~~~

追答

呃.这个不行啊.如果你只想了LIKP这个表的话,
那你就LOOP去查LIKP与LIPS好了,
这样会快些.