MySQL JOIN 4个不同的表 [英] MySQL JOIN 4 different tables

问题描述

如何联接这4个不同的表，以便获得字符串结果而不是数字.到目前为止，这是我的查询

How to join those 4 different tables so I can get string result instead of numbers. This is my query so far

SELECT mg_golub.ID AS IDgolub, mg_golub.brojgoluba, mg_golub.spol, 
       mg_golub.boja, mg_golub.rasa, mg_golub.ime, mg_golub.godina, 
       mg_drzava.drzava, mg_status.status
FROM mg_golub
JOIN mg_drzava 
  ON (mg_drzava.ID=mg_golub.IDdrzava)
JOIN mg_status 
  ON (mg_status.ID=mg_golub.IDstatus)
LEFT JOIN mg_popis_golubova AS Otac 
  ON (Otac.IDotac=mg_golub.ID)
LEFT JOIN mg_popis_golubova AS Majka 
  ON (Majka.IDmajka=mg_golub.ID)
JOIN mg_popis_golubova 
  ON (mg_golub.ID=mg_popis_golubova.IDgolub) 
WHERE mg_popis_golubova.IDkorisnik='$ID_KORISNIK' 

我不知道如何将这3个字段从mg_popis_golbova链接到mg_golub.我被困住了，因为我无法选择那两列的数据.

I don't know how to link those 3 fields from mg_popis_golbova to mg_golub. I'm stuck with, cause I can't pick data for those 2 columns.

LEFT JOIN mg_popis_golubova AS Otac ON (Otac.IDotac=mg_golub.ID)
LEFT JOIN mg_popis_golubova AS Majka ON (Majka.IDmajka=mg_golub.ID)

INSERT INTO `mg_golub` (`ID`, `IDkorisnik`, `brojgoluba`, `spol`, `boja`, `rasa`, `ime`, `godina`, `IDdrzava`, `IDstatus`) VALUES
(1, 1, '06557-07-681', 'X', 'kovana', 'Koopman x Schellens', 'Dirk', 2000, 2, 3),
(2, 1, '07216-05-552', 'X', 'kovana', 'Koopman', 'Tata', 2001, 2, 3),
(3, 1, '2081-01-271', 'Y', 'kovana', 'Schellens', 'Die Weischwantaubi', 2003, 2, 3);

INSERT INTO `mg_popis_golubova` (`ID`, `IDkorisnik`, `IDgolub`, `IDmajka`, `IDotac`) VALUES
(28, 1, 1, 3, 2),
(27, 1, 3, 0, 0),
(26, 1, 2, 0, 0);

推荐答案

尝试一下

   SELECT mg_golub.ID AS IDgolub, mg_golub.brojgoluba, mg_golub.spol, 
       mg_golub.boja, mg_golub.rasa, mg_golub.ime, mg_golub.godina, 
       mg_drzava.drzava, mg_status.status
FROM mg_golub
JOIN mg_drzava 
  ON (mg_drzava.ID=mg_golub.IDdrzava)
JOIN mg_status 
  ON (mg_status.ID=mg_golub.IDstatus)
JOIN mg_popis_golubova 
  ON (mg_golub.ID=mg_popis_golubova.IDgolub) 
WHERE mg_popis_golubova.IDkorisnik='$ID_KORISNIK' 

这篇关于MySQL JOIN 4个不同的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！