Junior1544
Technical User
I have a sql question... Here is the sql statement I currently have:
SELECT DISTINCT Gate.Name, Gate.Organization, Gate.PlateNum, Gate.PlateState, Gate.REC_ID FROM Gate;
REC_ID is a random number generated for easier record reference...
What happens when I use this statement, it returns all rows from the table because REC_ID is different in every record...
I need it to return the distinct for each row, then get the REC_ID that applies to the specified row... There is more data for times and date info in the table as well, but I don't include that in the sql because I don't need that at the time in the app...
Any idea's or questions for clairifacation, feel free to send me a note...
Thanks!
--James
Junior1544@jmjpc.net
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
SELECT DISTINCT Gate.Name, Gate.Organization, Gate.PlateNum, Gate.PlateState, Gate.REC_ID FROM Gate;
REC_ID is a random number generated for easier record reference...
What happens when I use this statement, it returns all rows from the table because REC_ID is different in every record...
I need it to return the distinct for each row, then get the REC_ID that applies to the specified row... There is more data for times and date info in the table as well, but I don't include that in the sql because I don't need that at the time in the app...
Any idea's or questions for clairifacation, feel free to send me a note...
Thanks!
--James
Junior1544@jmjpc.net
junior1544@jmjpc.net
Life is change. To deny change is to deny life.