ansis Posted November 8, 2005 Report Share Posted November 8, 2005 Sveicieni! Man sekojoss jautaajums: Ir 2 tabulas: vardi ------------- id_v | vards ------------- 01 | Janis 02 | Juris 03 | Peteris saites id_s | id_v_1 | id_v_2 ------------------------ 01 | 01 | 02 02 | 02 | 03 03 | 01 | 01 Kaads izskatiisies selects, lai dabuutu aaraa saites: 01 | Janis | Juris 02 | Juris | Peteris 03 | Janis | Janis Kameer ir viena saite, tikmeer es maaku. Kad ir saites uz 2 dazaadaam tabulaam (3 tabulu joins), arii var uzrakstiit. Bet, kad jaapraksta saite uz vienas tabulas 2 laukiem vienlaiciigi, taa aplauzos. :( Link to comment Share on other sites More sharing options...
bubu Posted November 8, 2005 Report Share Posted November 8, 2005 SELECT id_s, v1.vards, v2.vards FROM saites, vardi as v1, vardi as v2 WHERE id_v_1 = v1.id_v AND id_v_2 = v2.id_v Link to comment Share on other sites More sharing options...
ansis Posted November 9, 2005 Author Report Share Posted November 9, 2005 (edited) ... FROM vardi as v1, vardi as v2 ... Viltiigi - vienu un to pasu tabulu apsaukt 2 dazaados vaardos! :)) Paldies, Bubu! Edited November 9, 2005 by ansis Link to comment Share on other sites More sharing options...
hmnc Posted November 9, 2005 Report Share Posted November 9, 2005 kas tur viltīgs? uztaisa divas virtuālās kopijas vienai tabulai. pēctam dr* kā gribi :D Link to comment Share on other sites More sharing options...
bubu Posted November 9, 2005 Report Share Posted November 9, 2005 virtuālās kopijas vienai tabulai wtf ir virtuāla kopija? Link to comment Share on other sites More sharing options...
Recommended Posts