Połaczenie dwóch tabel PROBEM! Opcje

[grzegorz-gg]

Mam problem z połaczeniem dwoch tabel
pierwsza z nich to tabela products zawiera pola products_id, products_name, products_price a druga tabela to specials i zawiera pola specials_id, products_id, specials_price
products_id jest kluczem obcym tabeli products

Tabela products zawiera dwa rekordy

+---------------+--------------------+-------------------+
| products_id | products_name | products_price |
+---------------+--------------------+-------------------+
|1_________| koszula_______| 120.33______|
+--------------+---------------------+-------------------+
|2_________| spodnie_______| 230.00______|
+--------------+---------------------+-------------------+

a tabela specials zawiera jeden rekord

+--------------+---------------+------------------+
| specials_id | products_id | specials_price |
+--------------+---------------+------------------+
|1_________| 2________| 170.93______|
+--------------+---------------+------------------+


W jaki sposób wyswietlic dane z dwóch tabel aby otrzymac taki wynik?


+---------------+--------------------+-------------------+------------------+
| products_id | products_name | products_price | specials_price |
+---------------+--------------------+-------------------+------------------+
|1_________| koszula_______| 120.33______| ____________|
+--------------+---------------------+-------------------+------------------+
|2_________| spodnie_______| 230.00______| 170.93______|
+--------------+---------------------+-------------------+------------------+

Proszę o pomoc

[nospor]

[SQL] pobierz, plaintext 
SELECT * FROM tabela1 t1 LEFT JOIN tabela2 t2 ON t2.kluczdotabela1=t1.id
[SQL] pobierz, plaintext 

I se dopasauj