wyciągnięcie danych

[kendry]

Witam,

Mam dwie table:

CREATE TABLE `axent_storehouse_documents` (
`id` int(11) DEFAULT NULL,
`k_idklienta` int(11) DEFAULT NULL,
`wartosc` decimal(10,0) DEFAULT NULL,
`wartosc2` decimal(10,0) DEFAULT NULL,
`rok` text,
`tr_datasprzedaz` date DEFAULT NULL,
`tr_datawystaw` date DEFAULT NULL,
`tr_nsr` text,
`tr_fv` text,
`tr_flaga` int(11) DEFAULT NULL,
`zl_status` int(11) DEFAULT NULL,
`k_kod` text,
`tr_rodzaj` int(11) DEFAULT NULL,
`lt_nrobcy` text


CREATE TABLE IF NOT EXISTS `www_klienci` (
`client_id` int(11) NOT NULL AUTO_INCREMENT,
`kod` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`haslo` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`nazwa` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`miasto` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`kod_pocztowy` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`adres` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`telefon` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`fax` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`email` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`nip` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`zadluzenie` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`id_platnika` int(11) DEFAULT NULL,
`grupa_cenowa` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`rabat` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`galanteria` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mailing` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`updated` int(11) DEFAULT NULL,
`platnosc` int(11) DEFAULT NULL,
`www` varchar(245) DEFAULT NULL,
PRIMARY KEY (`client_id`)
)

Mam dwa selecty:

SELECT * FROM axent_storehouse_documents where tr_datasprzedaz = CURDATE() and wartosc=wartosc2
i
SELECT DISTINCT email FROM `www_klienci`, `axent_storehouse_documents` WHERE www_klienci.nazwa=axent_storehouse_documents.k_kod

Potrzebuję wybrać email gdy spełnione są warunki z tych dwóch selectów