Sql Whizz Needed 16.03.08
Currently, I have the following sql statement which order affiliates according to how many sales they have made:
mySQL=”select count(transactions.id) as aaa,hits, realname, members.id from members,transactions where members.id=transactions.referrerid group by members.id,members.realname,members.hits order by count(transactions.id) desc”
This connects up to one database.
However, what I want to do is to connnect up to two databases and add together the name of sales that each affiliate has made (according to the column realname). The make up of both tables is the same.
I am using ASP and sql server
Before bidding, please contact by PM indicating that you already have the answer.
