need help! (1 Viewer)

[mokhechen]

hi all , i have 2 tabels first one personal info have pnum,name,rank,dateofbirth.....
second have pnum related to pnum in personal info and medals_type .....
there is 12 medals type lets say medal1 2 3 4 5 .......
i want to find who dosent have medal 5 or 3 or 2 in parameter [ ]
and thanks for help! :banghead:

 

[John Big Booty]

You can use criteria;

<> 2 Or <> 3 Or <> 5

 

[mokhechen]

<> 1 or <>2 like "not like " i want to find persons who dosent has ( medal1 or medal 2 but may be he has medal3) example ; jhon has medal1 and medal2 but he dosent has medal3

 

[pr2-eugin]

Yes.. that is what the <> (not equals) does..

 

[mokhechen]

no lets say " john has medal1 and medal3 , tony has medal4 and medal3 , sam has medal1 and medal4 ............ i wana find who dosent has medal3 answer is" only sam"
not
jhon medal1
tony medal4
sam medal1,medal4
!!!!!!!

 

[pr2-eugin]

SELECT pName FROM pTable LEFT JOIN medalTable ON pTable.pNum=medalTable.mNum
WHERE medalTable.medalNumber <>3

Try the above code, by replacing the field names to your table and field names and see if you do not get sam as the output..

 

[mokhechen]

thank u for help
if i want to find who has medal1 and dont have medal3

 

[pr2-eugin]

The same, but now you should have the where as,

medalTable.medalNumber=1 AND medalTable.medalNumber<>3

 

[mokhechen]

can i send the database file????

 

[pr2-eugin]

Why what is wrong with the code? does it not work? Try working around the suggestions.. or tell us what you need, so we will try to help you.. I don't mind looking at it, though..

 

[mokhechen]

take a look please

 

[pr2-eugin]

What am I looking at again?? Please state your problem, and also what you expect??

 

[mokhechen]

did u saw the database file????

 

[pr2-eugin]

Yes, but I am not sure which Form / Query / Table I should look at. If you are not stating your problem/what you want I am afraid I can not help you...

 

[mokhechen]

look at query1 please ; i want it to show me only sam ,the only one who doesnt has med3