How to capture only last record of a table?

Question

The pure query (sql) below, only returns me one row of the table, it occurs that I am working with two tables (Process and Progress) and that progress has as foreign key the primary key of Process.

select fkcodprocesso, dtandamento, descricao from andamento 
order by str_to_date(dtandamento, '%d-%m-%Y') desc limit 1;

Answer 1

You forgot to set the process table after the "from", since you are using the two table (Process and progress) you have to reference the two, it will be good:

select pc.fkcodprocesso, at.dtandamento, at.Descricao FROM processo pc, andamento at order by str_to_date(at.dtandamento, '%d-%m-%Y') desc limit 1;