I read Kiran Pai's great tutorial on joins.
I have a related problem, selecting fields from two Dbs, the result will double up on roomnumbers. I don't want to display duplicates. Is there a way I can stop duplicates? The nature of the search will bring up duplicates, but I only want to show one of each field
Archive Import (Frederic Boulton) 
