I don't think it's impossible. It might be nicer if you could use a
sub-select. But here's join.
SELECT DISTINCT affiliates.id, DISTINCT
sales.client_id,SUM(sales.client_id)
FROM affiliates,clients,sales
WHERE affiliates.id = clients.affiliate_id AND sales.client_id =
clients.id;
e mysql versions are exactly the same and
> the db structures are the same it works.
>
> Otherwise mysqldump and read it into the new db:)
>
> //Uffe
> Witness wrote:
> >
> > Hello. I am running a MySQL server (3.23.43) on WinME, and another
> > server (same ve
Hello. I am running a MySQL server (3.23.43) on WinME, and another
server (same version) on libc6 Linux. The server on WinME is a
development server, or rather has been until now, and the Linux one is
my production server. At this time the Linux one is completely empty
with the exception of the d
