SELECT with INNER JOIN to display only one record

I was wander whether someone could help me with a query problem I am having

I have the following tables with data

cart_session
q_id userid itemid quanity datetime_cart
126 1 10 1 2012-01-16 14:55:26
125 1 23 1 2012-01-16 14:56:26

shop_details
s_id sessid firstname surname email address ordertype orderstatus postcode datetime
20 1 Bob Smith bob@smith 145 Address Pay started xx21 x1 2012-01-16 14:56:26

When I execute the below query I get the following resuls



Result
q_id userid itemid quanity datetime_cart s_id sessid firstname surname email address ordertype postcode datetime
126 1 10 1 2012-01-16 14:55:26 20 1 Bob Smith bob@smith 145 Address Pay started xx21 x1 2012-01-16 14:56:26
125 1 23 1 2012-01-16 14:56:26 20 1 Bob Smith bob@smith 145 Address Pay started xx21 x1 2012-01-16 14:56:26

But I only would like to get one top record. Do you think you would be able to help me with my problem.

Kind Regards;

Arek

Without an ORDER BY clause the concept of 'top' doesn't really mean a great deal as the order the data is returned is not guaranteed. What column would you use to define which is the top row in your example? Add an ORDER BY clause (probably DESC) on that column and a LIMIT 1 to only get the single row.