RE: Category box Performance

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=198829#198829
----------------------------------------------------------------

[quote="Aric"]i.e. what do the c. and c2. mean before those field names?[/quote]

In SQL you can give tables an alias like so:

[code]
SELECT p.products_id FROM products AS p
[/code]

The AS is left out most of the time. The part before the period refers to the table you're selecting from. 
(It's not really useful in this example, but when selecting from more than one table containing the same column name you need to specify the table obviously, and it improves readability on complex queries.

Rob