Hi! I have two table. PersonTable and InfoPersonTable.
PersonTable
|
Id
|
Name
|
|
1
|
Rustam
|
|
2
|
Asror
|
|
3
|
Sadriddin
|
|
4
|
Firuz
|
InfoPersonTable
|
Id
|
PersonId
|
Weight
|
High
|
Hair
|
Character
|
Mood
|
|
1
|
1
|
60
|
160
|
Black
|
Fanny
|
Good
|
|
2
|
2
|
90
|
195
|
White
|
Serious
|
Fine
|
|
3
|
1
|
60
|
160
|
Black
|
Fanny
|
Bad
|
|
4
|
2
|
90
|
195
|
White
|
Serious
|
Bad
|
Every day changing InfoPersonTable data because every morning I input about each people.
But now I want get last record for person from InfoPersonTable by Id. When I input Id = 1 then show last record about Rustam else if Id=2 then show last record about Asror.
For example Id = 1 output result:
Weight - 60
High - 160
Hair - Black
Character - Fanny
Mood - Bad
How I can solve this?
