Distinct Value on Query

[a1amattyj]

Hello,

 

The following query:

 

SELECT * FROM handsets, deals, tariffs

WHERE handsets.handet_numeric=deals.handset

AND tariffs.tarrif_numericid = deals.tarrif

AND deals.gift > 0

AND deals.cost_of_phone <= '0'

AND tariffs.cost_month != 0.00

ORDER BY handsets.launch_date DESC

LIMIT 8;

 

I would like to select only distinct rows with respect to deals.handset (no 2 results from this query will spit out the same deals.handset value).

 

How would I go about this?

 

(deals.handset is indexed, and is an integer value)

 

Thank you so much,

 

Matt

[Jessica]

SELECT DISTINCT deals.handset FROM .... the rest of your query.