I did not understand you much but would not this work? SELECT * FROM table WHERE typ='f' OR typ='i'
Jiří Němec wrote:
hello,
i have got a problem with SQL select:
I have got a table such this:
id_k typ name id 1 f bla1 1 2 f bla2 1 2 i bla3 1 3 z bla4 1 3 f bla5 1 4 i bla6 1 4 z bla7 1 5 z bla8 1
and id = 1 and I need select these rows:
id_k typ nazev id 1 f bla1 1 2 f bla2 1 3 f bla5 1 4 i bla6 1
so, when doesn'i exist component (id_k = component) type "f" so I want component with type "i", but when doesn't exist type "f" noir "i" I don't want to select row with type "z".
jiri nemec, ICQ: 114651500 www.menea.cz - www stránky a aplikace
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
