The "dbo" scope is the "owner" of the table. This means it was created by user "dbo." The "dis_products" scope is the name of the table the column belongs to. That's to eliminate ambiguity in multitable queries. "DESC" means descending. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -----Original Message----- From: Chad <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, August 28, 2000 5:22 PM Subject: Query syntax >ORDER BY dbo.dis_products.product_name DESC > >This is a part of a query that im trying to de-cipher. How can the >variable have two scopes? > >And what is DESC? > >Thanks >Chad >--------------------------------------------------------------------------- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.