works great cheers mate! Came by another problem though:
How do I go about when I want to sort on a field in the subquery(temp_test)? In access I'd only add
ORDER BY temp_test.whatever but how do I access a field in the subquery to sort on?
Thanks
I have this simple query in access:
SELECT Node_Interfaces.NODE_ID, Node_Interfaces.Interface
FROM Node_Interfaces INNER JOIN temp_test ON Node_Interfaces.NODE_ID = temp_test.NODE_ID;
which I'd like to use in an asp page. I want to query for all Interfaces that has the same NODE_ID as in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.