[sql]SELECT current_status,esn, count(*) as total
FROM jobs
WHERE esn IN ('357666011363899','354932015183557')
GROUP BY current_status,esn
Having total>1[/sql]
Results:
Code:
Current_Status ESN total
905 DES 357666011363899 3
Sumthing like this..... I want to see the results of the ESN though
Pleeeeeeeeeeease help
I want it to display all 3 esn number not just summarising them in total