No, not really like this. Unless you connect directly to the other site database using wpdb, look here: Using wpdb to connect to a separate database.
Otherwise, you could possibly achieve this using the JSON API plugin, but maybe security issue will occurs. There is also a lot of solutions to share content between websites, depending on what you want to share, try to be more specific.