Hello, I need to create a function that find data over 3 tables, merge and return data. With example can be specified more clearly:
1.1 Find all addresses code; 1.2 For each addresses code, get address, complement and city on the first table; 1.3 For each addresses code, get address, complement and city on the second table; 1.4 Merge result from first and second tables and return to the function; I would like to do not using cursor. Do you have any ideas how to implement? Thanks in advance. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
