How to make Join query to the database where the ID value is stored in the comma separated list?

Greetings, help to form a DB query using the ZendDB.

There are two tables:
NAME ADDRESS Course
------------------------------------------------
RAM ADDRESS 01,02,06,
HARI ADDRESS ,2,6,
JEFF ADDRESS ,3,5,6,7,
DAISY ADDRESS ,3,

Id Name Category
-----------------------
1 ABC IT
2 DEF IT
3 GHI WEB
4 JKL IT
5 MNO WEB
6 PQR WEB
7 STU IT

I need the result was merge 2 tables:
NAME ADDRESS Course
------------------------------------------------
RAM ADDRESS ['id', 'name', 'category' ]
HARI ADDRESS ['id', 'name', 'category' ]
JEFF ADDRESS ['id', 'name', 'category' ]
DAISY ADDRESS ['id', 'name', 'category' ]

Use Zend DB postroyaniya request.

$select = $db->select();
$select->from(array('university' => 'object_query_1'), array('*'));
$select->join(array('course' => 'object_query_2'), '??????????????????????', array('*'));
$universities = $select->query()->fetchAll();


Help to understand and make the correct request.
March 19th 20 at 09:52
1 answer
March 19th 20 at 09:54
Normalize database. It is not necessary to keep the information separated with commas

Find more questions by tags Zend Framework