I am trying to use the Data Enviroment to design an SQL which I can then use to make a report
The problem I am having is that I need to design two seperate SQL's and then combine them to get the appropriate info.
I was trying to use a hierachy but I'm not sure how to use it or if I can base a report on the parent object

At this stage the two child SQL's which give the data to combine are as follows

ClientQ: Select Distinct Client.CFName, Client.CLName, Agentrep.AFName, AgentRep.ALName, AgentRep.AgentID from agentrep, client where agentrep.agentid = client.agentid

HouseQ: Select House.HStreet, House.HSuburb, House.HPostCode, OInspect.ODate, OInspect.AgentID from House, OINspect where OInspect.ODate between #Date1# and #Date2#

Has anyone got any suggestions?????