Search found 1 match
- Fri Jul 31, 2020 10:12 am
- Forum: Archive
- Topic: How to create a SQL ordering based on JOIN values and on today month
- Replies: 0
- Views: 2772
How to create a SQL ordering based on JOIN values and on today month
I have two databases TABLE_ORDERS with id,created,user_id.....status_id TABLE_STATUSES with it,title,ordering,month ordering is an integer for ordering statuses and month is the month number (01-January, 02-February, ...) I would like to create something like: SELECT * FROM TABLE_ORDERS, TABLE_STATU...