Hi,
I have a table with 3 columns:
territory nº, house nº and street name
I would like to join houses nº and streets when territory ºs are equals
eg.
territory, house, street
230-3, cammeray rd
230-4, cammeray rd
230-5, cammeray rd
230-6, shilon st
232-7, cammeray rd
232-8, shilon st
i would like to return a table with two columns (territory and address):
territory,address
230-3,4,5 cammeray rd
Can anyone please help me
Thanks