Hi listers
i have two tables buildings and consumers.Some buildings may have more than one
consumer and some may have no consumer falling in that building.
i want to select the buildings with consumers. Now when i run the query
"Select * from buildings,consumers where buildings.obj contains
consumers.obj", The query is returning duplicate records.i.e if a particular
building has 2 consumers falling in it, the building is selected twice nad if
the building has 5 consumers in it, the building is selected 5 times.
Is there a way i can avoid this duplications.Please suggest a solution to this.
Thanks in advance
Sasidhar
