Link to home
Start Free TrialLog in
Avatar of _Esam
_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
ASKER CERTIFIED SOLUTION
Avatar of softplus
softplus

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial