Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.


Welcome to KnowledgeSutra - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

tinoymalayil's Photo

tinoymalayil

Member Since 20 Apr 2009
Offline Last Active May 16 2012 10:43 AM

Find content

About Me

I am a freelance Software Developer would like to share ideas,would like to design,coding ,chatting,learn new things etc..
having so many long term goals etc...

Community Stats

Group Kontributors
Active Posts 152 (0.13 per day)
Most Active In Software (23 posts)
Profile Views 8,952
Member Title Premium Member
Age 26 years old
Birthday October 16, 1985
Gender
Male
Location
India

Previous Fields

myCENT
23.11

Contact Information

0 Neutral

Friends

tinoymalayil hasn't added any friends yet.

Latest Visitors

sylvia4you
10 Jun 2011 - 12:01
CarltonWO
10 Mar 2011 - 19:04
chini13
20 Nov 2010 - 15:13
anwiii
01 Aug 2010 - 08:43
NNNOOOOOO
22 Jul 2010 - 03:54

Topics I've Started

Advantage Of Using The Join Operator

15 May 2012 - 08:20 AM

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.FILEDESC
FROM CRSETYPE CT JOIN CRSE CM
ON CT.CRSEID,=CM.CRSEID,
WHERE CT.TYPE=1

Query without JOIN Operator

SELECT CM.CRSEID,CM.CRSENAME, CM.CRSELOGINID,CM.FILEPATH,
CM.FILEURL,CM.FILEDESC
FROM CRSETYPE CT,CRSE CM
WHERE CT.TYPE=1 AND CT.CT.CRSEID,=CM.CRSEID

Please Reply

Regards,
Tinoy