diky
btw neni tohle trochu moc ? (+ dalsich 12 moznych podminek a razeni)

SELECT products_ssr.nazev, konfssr_proud.udaj AS proud, konfssr_vystupnap.udaj AS vystupnap, konfssr_spickanap.udaj AS spickanap, konfssr_rozsahsigssr.udaj AS rozsahsigssr, products_ssr.charakterspinani, products_ssr.pocetfazi, products_ssr.chladic, products_ssr.montazssr, products_ssr.prepetovaochrana, products_ssr.charaktersignalu, konfssr_rozsahnapeti.udaj AS rozsahnapeti, konfssr_rozsahproudu.udaj AS rozsahproudu, products_ssr.cena
FROM products_ssr, konfssr_proud, konfssr_rozsahnapeti, konfssr_rozsahproudu, konfssr_rozsahsigssr, konfssr_spickanap, konfssr_vystupnap
WHERE products_ssr.proud = konfssr_proud.id
AND products_ssr.rozsahnapeti = konfssr_rozsahnapeti.id
AND products_ssr.rozsahproudu = konfssr_rozsahproudu.id
AND products_ssr.rozsahsigssr = konfssr_rozsahsigssr.id
AND products_ssr.spickanap = konfssr_spickanap.id
AND products_ssr.vystupnap = konfssr_vystupnap.id