Is there really no other way to get the results from another table? If there is a complex relationship between two tables, it might be simplified by a series of tables in between which already exist.
For example, supposing you have a student table and a teacher table. A student can have many teachers and a teacher can have many students.
However, before creating an associative table to link them, suppose there already exists a table classroom by which a teacher has many and a student has many.
Without creating a table for this purpose you can use table classroom. Of course this is an example which spans one table, though there may be more tables to use in order to make this connection.