I have 2 tables one table named as projects and project details, projects is the master table of project details and i am getting records by subquery as:

SELECT id, (select project_name from project_details where id=project.projectID) as property_master_project, filed2,field3 FROM projects WHERE ORDER BY property_master_project asc



id=354, property_master_project=Arabian Ranches
id=355, property_master_project=Arabian Ranches
id=361, property_master_project=Arabian Ranches
id=459, property_master_project=Arabian Ranches
id=467, property_master_project=Arabian Ranches

I want to know how order by is working when project names are same (ORDER BY property_master_project asc ) as i want all projects sequence by ids so that it should show as:


id=354, property_master_project=Arabian Ranches
id=355, property_master_project=Arabian Ranches
id=359, property_master_project=Arabian Ranches
id=461, property_master_project=Arabian Ranches
id=467, property_master_project=Arabian Ranches


I have tried as
ORDER BY property_master_project, id asc
ORDER BY property_master_project asc, id asc