Posts by Magno Costa • 96 points
3 posts
-
1
votes1
answer76
viewsA: Metaprogramming with ruby on Rails in a partial
A suggestion is to do so: 1) Create a Concern for templates that may have extract you will need to use. Remembering that the Concerns should be in the models/Concern folder so Rails will…
-
1
votes1
answer357
viewsA: How to mount an Inner Join by filtering through a field with minimum value?
You should do it like this: SELECT MIN(co.data_vencimento), c.cpf FROM cliente c INNER JOIN contrato co ON co.cpf = c.cpf INNER JOIN pagamento p ON p.COD_CONTRATO = co.COD_CONTRATO INNER JOIN…
oracleanswered Magno Costa 96 -
3
votes2
answers508
viewsA: How do I do INNER JOIN in this case?
You should do it like this: SELECT * FROM users_data a INNER JOIN users_type b ON b.id = a.user_type_id WHERE user_id = {0} This taking into account that your table "users_data" has the field…