Greywacke Posted March 7, 2010 Report Share Posted March 7, 2010 hi there,i am using MySQL, and trying to process the following select statement: SELECT 10_serviceprospects.bigint_ProspectID, 5_suppliers.text_SupplierName, 5_suppliers.text_ContactFirstName, 5_suppliers.text_ContactSurname, 5_suppliers.text_ContactPosition, 5_suppliers.`text_ContactE-mail`, 5_suppliers.bigint_ContactTel, 13_prospectleadsent.timestamp_Sent, 12_prospectmessages.smallint_ProspectMessageCount FROM 13_prospectleadsent, 5_suppliers, 12_prospectmessages, 10_serviceprospects WHERE 13_prospectleadsent.bigint_SupplierID = 5_suppliers.bigint_SupplierID AND 13_prospectleadsent.bigint_MessageID = 12_prospectmessages.bigint_MessageID AND 13_prospectleadsent.bigint_ProspectID = 10_serviceprospects.bigint_ProspectID AND 13_prospectleadsent.bigint_ProspectID = 1 ORDER BY 12_prospectmessages.smallint_ProspectMessageCount ASC, 5_suppliers.text_SupplierName ASC; however, they only seem to order by the 12_prospectmessages.smallint_ProspectMessageCount field. how can i make them order like i attempted to here, with a primary and secondary order? the correct fields are returned, just in the wrong order...someone please help! Link to comment Share on other sites More sharing options...
boen_robot Posted March 7, 2010 Report Share Posted March 7, 2010 Have you tried outputting 12_prospectmessages.smallint_ProspectMessageCount? It may reveal why it's not ordering the results correctly. Can you provide some minimal data sample where this problem occurs? Link to comment Share on other sites More sharing options...
Greywacke Posted March 7, 2010 Author Report Share Posted March 7, 2010 nevermind, sighs... this issue has been resolved :)here is the correct select statement SELECT 10_serviceprospects.bigint_ProspectID, 5_suppliers.text_SupplierName, 5_suppliers.text_ContactFirstName, 5_suppliers.text_ContactSurname, 5_suppliers.text_ContactPosition, 5_suppliers.`text_ContactE-mail`, 5_suppliers.bigint_ContactTel, 13_prospectleadsent.timestamp_Sent, 12_prospectmessages.smallint_ProspectMessageCount FROM 13_prospectleadsent, 5_suppliers, 12_prospectmessages, 10_serviceprospects WHERE 13_prospectleadsent.bigint_SupplierID = 5_suppliers.bigint_SupplierID AND 13_prospectleadsent.bigint_MessageID = 12_prospectmessages.bigint_MessageID AND 13_prospectleadsent.bigint_ProspectID = 10_serviceprospects.bigint_ProspectID AND 13_prospectleadsent.bigint_ProspectID = 1 ORDER BY 5_suppliers.text_SupplierName ASC, 12_prospectmessages.smallint_ProspectMessageCount ASC Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now