hy, maybe im blind about this problem: thats a row of my table(sql follows at the endof that mail) named immo_kat
kat_id - immo_id - cr_uid - tstamp ------ ------- ------ ------ ... 35 - 318 - 1 - 1015874898 34 - 318 - 1 - 0 ... now i like to get all immo_id's which have the same kat_id's like the rows with the immo_id "318". With one query means a join between two selects - I. SELECT kat_id FROM immo_kat where immo_id = 318 an with the result : II. SELECT immo_id FROM immo_kat where kat_id = '1' OR kat_id = '35' OR kat_id = '34' Group by immo_id I'm sorry - sound really easy - but maybe its to late I would be very glad if someone can help me heres the sql if needed # # Tabellenstruktur für Tabelle `immo_kat` # CREATE TABLE immo_kat ( kat_id int(11) NOT NULL default '0', immo_id int(11) NOT NULL default '0', cr_uid int(11) NOT NULL default '0', tstamp int(11) NOT NULL default '0', KEY kat_id (kat_id) ) TYPE=MyISAM; # # Daten für Tabelle `immo_kat` # INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (1,318,1,''); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (1,277,1,''); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (35,318,1,''); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,277,1,''); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,318,1,''); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (36,315,1,1015874898); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,315,1,1015874898); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (1,299,1,1015876885); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,311,1,1015876881); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (36,313,1,1015876875); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,327,1,1015875896); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (1,289,1,1015876892); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (34,289,1,1015876892); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (36,289,1,1015876892); INSERT INTO immo_kat (kat_id, immo_id, cr_uid, tstamp) VALUES (35,298,1,1015876904); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php