When i work with the sql, i have found the following two queries with and without JOIN Operator returns the same output.Can anybody help which method is more suitable? Query with JOIN Operator
SELECT CM.CRSEID,CM.CRSENAME, CM.CRSELOGINID,CM.FILEPATH,CM.FILEURL,CM.FILEDESCFROM CRSETYPE CT JOIN CRSE CMON CT.CRSEID,=CM.CRSEID,WHERE CT.TYPE=1
Query without JOIN Operator SELECT CM.CRSEID,CM.CRSENAME, CM.CRSELOGINID,CM.FILEPATH,CM.FILEURL,CM.FILEDESCFROM CRSETYPE CT,CRSE CMWHERE CT.TYPE=1 AND CT.CT.CRSEID,=CM.CRSEID
Please Reply Regards, Tinoy