Order by field
Posted 02 January 2004 - 06:29 AM
Posted 02 January 2004 - 09:50 AM
I have a 2 fields called sales and price. Within the sales field there is records \'sales center\', \'agentnames\'(agentnames is the names for the agents). I want to order by price but list the agentnames first which will be ordered by price then list the sales center ordered by price. Is there a way i can do this?
Can we get some terminology straight? You say you have 2 fields called sales and price, but it sounds like you have two \"Tables\".
Mysql works like this:
--Tables are defined by a set of
You insert Rows into a Table. (A row is synonymous with a \"Record\" or \"Tuple\")
Your misuse of the proper terminology makes it impossible to answer your question with anything but a guess.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users