Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
Node is saved as draft in My Content >> Draft

  • How to Use 'NOT LIKE' using 'JOIN' Command ?

    @ashwanimishra
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 415
    Comment on it

    'NOT LIKE' clause:

    NOT LIKE In contrast with the LIKE is used to eleminate the those field which we matches with specfic Criteria.

    For example : If we considered the Table named 'bookings', 'facilities' and 'members' then following command will help in joining these Table and will eliminate the those name which have the booking name 'Tennis Court' and there joining date should be between  '21-09-2012' to '22-09-2012'  and display there starttime and name  using JOIN Clause including with NOT LIKE.

    Select starttime,name from (cd.bookings JOIN cd.facilities ON cd.bookings.facid=cd.facilities.facid) JOIN cd.members ON
cd.members.memid=cd.bookings.memid where name NOT LIKE 'Tennis Court%' AND joindate>='2012-09-21' AND joindate<='2012-09-22' order by starttime

     

    sql join with Not Like mysql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: