wudu Posted February 27, 2006 Report 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...
Klez Posted February 27, 2006 Report 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
wudu Posted February 28, 2006 Author Report Posted February 28, 2006 juuhuu, ar nelielaam modifikaacijaam sanaaca =] paldies!
Recommended Posts