I need to get the latest activity from the database and order them by created_at.
There is a database table of orders, which has a shop_id, and there is a database table of collected_birthdays, which also has a shop_id incommon.
How to get the latest orders and collected_birthdays which has the same shop_id and take 5 latest records?
The mission is to display to the user the latest records of the two database tables, in the future, there will be more tables which will I need to display and get the latest 5 records.
Currently I tried joining the tables, but it merges to one and the created_at value stays only from the one table.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire