query with 2 tables problem

[zajkowsky]

Hello!
I'm beginner of sql and access and i need help. Probably this problem is easy , so :
I have 2 tables : In first are information like salary,birthday. In second.... this photo shows situation :



Destination of my task is show name and surname of person who have minimum wage. Now, this program shows only a minimum wage , but i dont know , what i have to write to this code to show only name and surname of person who have minimum wage.Here you are SQL code which can show more !
[sql]SELECT Min(Dane_osobowe.pensja) AS MinimumOfpensja
FROM Dane_osobowe INNER JOIN Pracownicy ON Dane_osobowe.kod_prac = Pracownicy.kod_prac;
[/sql]


sory for language here is translation of table's name's :
kod_prac = employee's ID
pesel (is not important)
data_ur - birthday


pensja = salary
nazisko = surname
imie = name
rest is not important!

[June7]

Your image did not attach to post.

Min is an aggregate function. Must be used in a Totals query. Access Help has guidance on building Totals (aggregate) query (uses a GROUP BY clause).