Good article, especially for beginners, but useful as a simple refresher.

We discuss joins quite often in optomizing code and it's amazing how many developers forget the basic rules.

Waiting for the next article on joins though ...

from
receiver_line rl
	left outer join receiver r 
		on (r.id=rl.receiver_id) 
	left outer join receiver_line_del rld 
		on (rl.receiver_id = rld.receiver_id and rld.receiver_line_no=rl.line_no)
	left outer join purc_order_line pol 
		on (rl.purc_order_id = pol.purc_order_id and rl.purc_order_line_no = pol.line_no)
	left outer join purchase_order po 
		on (po.id=rl.purc_order_id)
	left outer join purc_line_del pld 
		on (pol.purc_order_id = pld.purc_order_id and pld.purc_order_line_no = pol.line_no)
	left outer join vendor v 
			on (po.vendor_id=v.id)