more efficient cart content display using SQL db

["Otis Gospodnetic" <otis@DOMINIS.com>]

Hello,

I'm wondering if there is a simple/efficient way of retrieving information
about the product that a user added to the shopping cart for displaying in a
shopping cart page.

The product info that I want to show resides partically in a table (MySQL)
called 'products' (product_id and product_name are there) and partially in
another table called product_term (prices are there).

I know I could probably use something like this:

[if items]
[then]
[item-list]
[sql type=list query="SELECT sub_length, sub_type, sub_newrenew,
issues_per_year, sug_retail_price,
our_retail_price,special_instructions_for_customers FROM product_term
WHERE product_id = '[item-code]'"]
...
...

...but I'm thinking that there may be a better, more efficient way of
retrieving product info. Something that wouldn't require that I do this SQL
SELECT statement again (because the same SQL is done when displaying product
information using flypage).

Thanks,

Otis