|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
hi all im new here
ok and now to the problem i facing i have 3 tables Henk (htun, snimi, svuosi, kunta, palkka) Proj (ptun, pnimi, priorit, sijainti) Prhe (ptun, htun, tunnit, tunnit_suun) and i need to get the names of Proj (pnimi) which contains atleast 1 emplyee (from Henk table) whos born 1935 (svuosi) i have tried the following SELECT Proj.pnimi, Henk.htun, Henk.svuosi FROM Proj, Henk WHERE Henk.svuosi =1935 this gives all ...pnimi, htun, svuosi only that svuosi is now the 1935 like it should but what needs to be done to get only the names of pnimi which contains atleast 1 whos born 1935?? i think you need my database to help me out so this is the link to it http://a.1asphost.com/risto/SQL%20tiedostot/SQL/SQL.mdb and if you got any questions post it here or send me an email risto_hautamaki@suomi24.fi thankyou in advance...i hope i explained things correctly and sory if i have poor english ![]() |
|
#2
|
|||
|
|||
|
Try
SELECT Proj.pnimi, Henk.htun, Henk.svuosi FROM Proj INNER JOIN (Henk INNER JOIN Prhe ON Henk.htun = Prhe.htun) ON Proj.ptun = Prhe.ptun WHERE (((Henk.svuosi)=1935)); S- |
|
#3
|
|||
|
|||
|
IT WORKS
![]() thankyou very much ![]() |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Urgent help with sql needed |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|