Quote Originally Posted by tcarden View Post
the query is this:
select count(*) as total from zen_products p, zen_products_description pd .....etc.

what does the 'p' and the 'pd' mean following the table names??, unfamiliar w/ such a syntax.

thanks!
The construct zen_products p, zen_products_description pd defines a 'shorthand notation' that will be used in the query. Further in the query, you might find some variables referenced as p.products_id and pd.products_id which refer to the products_id field in the products table and the same field in the products_description table, respectively.