Malo konfuzno, ispada da ti Access kao nesto generise, a tebi se to ne svidja ...
Ako sam te dobro razumeo, tebi treba ovo:
Code:
SELECT Clanovi.*
FROM (Clanovi
INNER JOIN Prihodi AS GlavniPrihodi ON Clanovi.IdVisinePrihoda = GlavniPrihodi.IdPrihoda)
INNER JOIN Prihodi AS OstaliPrihodi ON Clanovi.IdVisineOstalihPrihoda = OstaliPrihodi.IdPrihoda
WHERE GlavniPrihodi.Visina = 2000 OR OstaliPrihodi.Visina = 2000
Nisi naveo kog je tipa polje Visina, pa sam pretpostavio da je numerickog tipa, a ako je znakovnog tipa onda samo dodaj apostrofe.
vidi GoranVucicevic #28045
www.clickersoftware.com
Registrovani: 102 ( srdjansto, Cola, daysleeper025, tata.stefan, alexandar_1980, Stapaloto, darkon, zecs, zoroit, ngavric, U.F.O, nebojsa milicevic, comi 1342, irm, spulkan, zzzz, tedi97, jsmith, Mister_rap, zonic, Miroslav Cvejić, mserifov, madamov, Miso Tanaskovic, Galenika, Odisejyu, nycwalker, skyline-GTR, jockeal, smsoft, diplodok, perun85, lekakg, calimero, Nebojsa Milanovic, vujanac borisav, eldin0007, TEXASSrbija, smars, Ankalagon the Black, rsinisa, Boe, beljabeli, nenen, Sica011, gigamg1, stdugisa, Kuca-buke, Dark_Runger, dusans64, radisasvr, a1200, ikocar, tassotti, denter, ventura, DZomba, X Files, dejan_m90, kale, ogylab, irenabp, stolay, Isak666, dautm, pags, bluebird, nsimic07, Laslo, Talaris, DusanSukovic, pajaja, malisha, ninabane, dejanptt87, Not now, John!, bkaradzic, RakiSat, Zoran Rodic, Catch 22, Radovan_Dz, Masamunea, MixKg, waikiki, STEFAN00000, NightShift_MKD, Schmidt, 30011992, 1vi, ahme, wagen, nuno, x3mer, milutin.petkovic, huskic, Safet Beriša, timmy, sucur, guslac, P_iaa_r, jericho1405, calexx )
Dvostruka relacija i SQL upit