pobieranie danych z 2 tabel nawer jak ... Opcje

[acztery]

witam mam taki kłopot

mam 2 tabele

1. Nazwy
2. Wartosci przypisane do danej nazwy

i teraz chce wyswetlic wszystkie nazwy a obok och wartosci pobrane z tej 2 tabeli. Działa.
Ale jezeli w 2 tabeli nie ma danej wartosci dla danej nazwy, sama nazwa nie zostaje wyswetla a ja bym chcial aby byla wysetlona z tym ze byla by pusta.

mam takie zapytanie

[SQL] pobierz, plaintext 
SELECT * 
FROM `forms` LEFT JOIN `forms_data` ON `forms_data`.`Id`=`forms`.`Id` 
WHERE ( forms_data.FromId = '1' ) AND ( forms_data.ParentId = 'test' ) GROUP BY forms.Id
[SQL] pobierz, plaintext 

[acztery]

to samo, dalej pokazuje tyle te reokry z 1 tabeli ktore maja wartosci w 2... (IMG:http://forum.php.pl/style_emoticons/default/sad.gif)

taka struktura

[SQL] pobierz, plaintext 
CREATE TABLE `forms` (
  `Id` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Name` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Label` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Type` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `FromId` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Extra` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Ord` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Default_value` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Time` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Date` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Deleted` enum('N','Y') character SET utf8 collate utf8_polish_ci NOT NULL DEFAULT 'N',
  `Required` enum('N','Y') character SET utf8 collate utf8_polish_ci NOT NULL DEFAULT 'N',
  `FromName` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Struktura tabeli dla  `forms_data`
-- 
 
CREATE TABLE `forms_data` (
  `Id` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `ParentId` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `FromId` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `Time` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,
  `value` text character SET utf8 collate utf8_polish_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[SQL] pobierz, plaintext 

Ten post edytował acztery 15.03.2007, 13:32:33