How to sql-sync prefixed multi-site installations within the same database with drush?
sql-sync does not support prefixed database tables.  There is work going on in the issue queue to support removal of cache tables via wildcard expressions. Perhaps this code could be adapted to support prefixed tables as well, if a motivated contributor would write and submit a patch.