Get first and last record

can anybody help me?

I have two tables in my app.

I need the first value of “saldo_inicial” and the last “saldo_atual” result from the table “apostas_matheus” where “mes” and “ano” are equal to the “lucro_mensal” table (“mes” and “ano”).
I will subtract both to get my monthly profit

And would this be the best way? Thank you very much

Solved Solved
0 2 936
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

View solution in original post

2 REPLIES 2
Top Labels in this Space