You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/04/03 06:01:26 UTC
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5055: Can
it support cross database join which have different tables
kimmking commented on issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055#issuecomment-608246389
If db0 and db1 in the same mysql instance, you can query
`select u.*, c.name as class_name from db0.user u, db1.class c
where u.username="test" and u.class_id=c.id `
Otherwise, mysql can't support.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services