Thank you much - I somewhat understand the query that you posted now.
The problem that I'm dealing with NOW however is that it will only
display results if there is a second level referree. I need to get
results despite whether there are six levels or referrals, or only one.
I added a third
The queries will be a little complicated using a self join, but the table
is simple should include:
CUSTOMERID
REFERRERID (Which is the CUSTOMERID of their referrer)
CUSTOMERFIRSTNAME
CUSTOMERLASTNAME
ETC!
The queries will then use a self join and table aliases to determine the
commissions for
