Why mysql querry doesnt match with what i though? : *sorry for my bad eng :(
Guyss...
Please help me,... i just learn MySQL, and i dont get why "permasalahan_khusus" doesnt match with "nama_psikolog" :(

please explain where did i go wrong


select customer.nama_customer, psikolog.nama_psikolog, tipe_permasalahan.permasalahan_khusus from customer cross join psikolog,tipe_permasalahan where customer.id_permasalahankhusus=psikolog.id_permasalahankhusus=tipe_permasalahan.id_permasalahankhusus;
+------------------+-------------------+---------------------+
| nama_customer    | nama_psikolog     | permasalahan_khusus |
+------------------+-------------------+---------------------+
| Sarah            | Heryawan Bambang  | Kriminal            |
| Susi Chandrawati | Nur Hasanah       | Kriminal            |
| Jaka             | Marcella Sondakh  | Kriminal            |
| Cipto Tambunan   | Marcella Sondakh  | Kriminal            |
| Nina             | Marcella Sondakh  | Kriminal            |
| Anindyta         | Heryawan Bambang  | Kriminal            |
| Alyani           | Marcella Sondakh  | Kriminal            |
| Wisna Jaya       | Muhammad Firyanto | Kriminal            |
| Indra Cahyo      | Muhammad Firyanto | Kriminal            |
| Krisna           | Nur Hasanah       | Kriminal            |
+------------------+-------------------+---------------------+