Jump to content
xisto Community

Search the Community

Showing results for tags 'sql tuning'.


More search options

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Forums

  • Help & Support
    • Alerts, News & Announcements
    • Web Hosting Support
    • Introductions
  • Computers & Tech
    • Science and Technology
    • Software
    • The Internet
    • Search Engines
    • Graphics, Design & Animation
    • Computer Gaming
    • Websites and Web Designing
    • Mobile Phones
    • Operating Systems
    • Programming
    • Online Advertising
    • Hardware Workshop
    • Computer Networks
    • Security issues & Exploits
  • Others
    • General Discussion
    • Business Forum
    • Photography
    • Health & Fitness
    • Dating And Relationships
    • The Vent
    • Art & Creativity
    • Home & Garden

Find results in...

Find results that contain...


Date Created

  • Start

    End

Last Updated

  • Start

    End

Filter by number of...

Joined

  • Start

    End

Group

Website URL

Location

Interests

Found 1 result

  1. tinoymalayil
    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
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept