[MySQL] podzapytanie przy wyszukiwaniu pełnoteksotwym Opcje

[szybki]

[SQL] pobierz, plaintext 
SELECT home.*, c.name AS city, c.country_id AS country_id, co.name AS country_name
        FROM home AS home, cities AS c, countries AS co
        WHERE home.city_id=c.id AND 
        co.id = c.country_id AND 
 
        MATCH (home.name, home.description) AGAINST("+'.$_GET['search'].'" IN BOOLEAN MODE) 
        ORDER BY home.id DESC LIMIT 4 OFFSET 4
[SQL] pobierz, plaintext 

Jak do tego zapytania dodać kolejne, aby na podstawie ID pobrało dane z innej tabeli?

Czyli aby dodatkowo wykonało sie:

[SQL] pobierz, plaintext 
SELECT * FROM b2h WHERE home_id=home.id
[SQL] pobierz, plaintext 

Ten post edytował szybki 1.10.2015, 08:52:59

[JanuszPHP]

[SQL] pobierz, plaintext 
SELECT home.*,b.*, c.name AS city, c.country_id AS country_id, co.name AS country_name
        FROM home AS home, cities AS c, countries AS co
JOIN b2h b WHERE b.home_id=home.id
        WHERE home.city_id=c.id AND 
        co.id = c.country_id AND 
 
        MATCH (home.name, home.description) AGAINST("+'.$_GET['search'].'" IN BOOLEAN MODE) 
        ORDER BY home.id DESC LIMIT 4 OFFSET 4
[SQL] pobierz, plaintext