wudu Posted February 27, 2006 Report Share Posted February 27, 2006 ir 2 tabulas tabula A: id | name | url | email | --------------------------- 1 | oto1 | w1 | mail1 | 2 | oto2 | w2 | mail2 | 5 | oto3 | w3 | mail3 | tabula B: uid | text -------------- 2 | teksts1 2 | teksts2 5 | teksts3 beigaas veelos ieguut shaadu rezultaatu: oto2 | w2 | mail2 | teksts1 | oto2 | w2 | mail2 | teksts2 | oto3 | w3 | mail3 | teksts3 | respektivi vajag uzzinaat cilveeka vaardu, emailu, urli un vinja tekstu no tabulas B. galvenaa tabula skaitaas B (ti. buus tik row'i, cik ierakstu ir shajaa tabulaa). izmeegjinaajos visaadi, bet nekaa... Link to comment Share on other sites More sharing options...
Klez Posted February 27, 2006 Report Share Posted February 27, 2006 select a.name, a.url, a.email, b.text FROM tabula A AS a, tabula B AS b WHERE b.uid=a.id ORDER BY a.id DESC vaidzeetu straadaat Link to comment Share on other sites More sharing options...
wudu Posted February 28, 2006 Author Report Share Posted February 28, 2006 juuhuu, ar nelielaam modifikaacijaam sanaaca =] paldies! Link to comment Share on other sites More sharing options...
Recommended Posts