_Esam
asked on
What's the equivalent of this Ms access in vb.net
SELECT COURSE_ID, COURSE_NAME FROM COURSES WHERE (COURSE_ID NOT IN (SELECT COURSE_ID FROM COURSES_TAKEN WHERE UST_ID=1204));
I want to do it like:
Dim dass As New OleDbDataAdapter("SELECT COURSE_ID, COURSE_NAME FROM COURSES (WHERE COURSE_ID NOT IN (SELECT COURSE_ID FROM COURSES_TAKEN WHERE UST_ID= " & User_ID));, cnss)
Or what's the proper syntax...?
Esam
I want to do it like:
Dim dass As New OleDbDataAdapter("SELECT COURSE_ID, COURSE_NAME FROM COURSES (WHERE COURSE_ID NOT IN (SELECT COURSE_ID FROM COURSES_TAKEN WHERE UST_ID= " & User_ID));, cnss)
Or what's the proper syntax...?
Esam
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.