Why SQL Query Not Working?
Confluence User - 23 Apr, 2018
Hello everyone. Can anyone tell me why my query is not working?
Query that works:
SELECT app_fd_info_staff.c_infoStaffId, app_fd_info_aset.c_assignAset
FROM app_fd_info_staff, app_fd_info_aset
WHERE app_fd_info_staff.c_infoStaffId = app_fd_info_aset.c_assignAset
Query that does not work:
IF EXISTS (SELECT app_fd_info_staff.c_infoStaffId, app_fd_info_aset.c_assignAset
FROM app_fd_info_staff, app_fd_info_aset
WHERE app_fd_info_staff.c_infoStaffId = app_fd_info_aset.c_assignAset)
BEGIN
PRINT 'Records exist'
END
ELSE
BEGIN
PRINT 'Record does not exists'
END
sql;mysql;query;select;forms;field