SELECT [description] & ' (' & [size] & '/' & [colour] & ')' AS prod_name, order_detail.* FROM (order_detail INNER JOIN product ON order_detail.prod_id = product.prod_id) INNER JOIN product_class ON product.prod_class = product_class.prod_class WHERE (((order_detail.session_id)= '987078335')) ORDER BY order_detail.prod_id

Camel Toe Clothing Shopping Cart
	'Go the Toe' T-Shirt (Small/White)	$25.00	$25.00
Total Spend:			$25.00