Stop SQL returning the same result twice in a JOIN
- by nbs189
I have joined together several tables to get data i want but since I am new to SQL i can't figure out how to stop data being returned more than once.
her's the SQL statement;
SELECT
T.url,
T.ID,
S.status,
S.ID,
E.action,
E.ID,
E.timestamp
FROM tracks T, status S, events E
WHERE S.ID AND T.ID = E.ID
ORDER BY E.timestamp…