TABLE_ORDERS with id,created,user_id.....status_id
Code: Select all
TABLE_STATUSES
ordering is an integer for ordering statuses and month is the month number (01-January, 02-February, ...)
I would like to create something like:
Code: Select all
SELECT *
FROM TABLE_ORDERS,
TABLE_STATUSES
WHERE 1
AND TABLE_STATUSES.month >= '7'
ORDER BY TABLE_STATUSES.ordering
What should be the right syntax?
Thank you for your support!