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