Is it possible to display data from an unrelated table?

Question

MySQL

Is it possible to display data from an unrelated table together? There are two modules, their tables are not related, but I need to output data from another model through one model. How can I do that ?

Answer 1

array(
            'name' => 'street',
            'value' => function ($data) {
                $output = "";
                if ($data->street instanceof Street) {
                    $output .= $data->street->Street;
                    if ($data->street->town instanceof Town) {
                        $output .= "," . $data->street->town->Town;
                    }
                }
                return $output;
            },
        ),

as an acceptable option

Answer 2

Why don't you use JOIN?