Typically when using the C API, when you do a Select, MySQL hands back a virtual table where the fields (columns) are marked with various kinds of info - their name and source table, as you might expect, but also stuff like whether this field is the primary key for its table.
So for example if I say this: select * from products join units where products.productid = units.productid I get back a table with all the fields from both products and units, and products.productid is marked as primary, and so is units.unitid (which is correct). Now for the problem. When I use the "order by" keyword, as follows: select * from products join units where products.productid = units.productid order by productnumber the primary key information doesn't arrive. Should it, or am I expecting too much? -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php