Skip to Content
0
Former Member
Jul 30, 2007 at 02:20 PM

alternative for inner joins

18 Views

Hi,

please check this code and suggest me of an alternative for this performance wise.

SELECT b~partner

APPENDING CORRESPONDING FIELDS OF

TABLE t_db_pos_match

FROM adrc AS a

JOIN but020 AS b

ON aaddrnumber = baddrnumber

JOIN but000 AS c

ON bpartner = cpartner

WHERE c~partner NE t_bp_obj-act-ekun-partner

AND c~mc_name1 = t_bp_obj-act-ekun-name_last

AND a~city1 = wa-city1

AND a~post_code1 = wa-post_code1

AND a~po_box = wa-po_box

AND a~street = wa-street

AND a~house_num1 = wa-house_num1

AND a~house_num2 = wa-house_num2

AND a~region = wa-region

AND a~addr_group = 'BP'.

awaiting your reply.

Binay.