Skip to Content
0
Former Member
Jan 05, 2007 at 03:24 PM

SELECT WITHOUT JOIN

32 Views

Sorry people..

How can i do this without join????

SELECT cbldat cbukrs clifnr pname1 crmwwr cbelnr c~gjahr

*c~cpudt

  • creindat cxblnr

  • FROM rbkp AS c

  • INNER JOIN lfa1 AS p

  • ON cmandt = pmandt AND

  • clifnr = plifnr

  • INTO TABLE it_output

  • WHERE c~blart IN p_blartm AND "Tipo de cod

  • c~bukrs IN p_bukrs AND "Sociedad

  • c~lifnr IN p_lifnr AND "Codi Acreedor

  • c~cpudt IN p_cpudt AND "Fecha CPU

  • c~gjahr IN p_gjahr. "Ejercicio