SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2006
    Posts
    62
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problems with delete query

    i have this query:
    DELETE FROM comuni WHERE comune in (SELECT nome from localita)


    but if comune='Ancona' and nome='ANCONA' the row in not delete.
    Why?
    How can i do?
    Thanks

  2. #2
    An average geek earl-grey's Avatar
    Join Date
    Mar 2005
    Location
    Ukraine
    Posts
    1,403
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    DELETE FROM comuni
     WHERE LOWER(comune)
        IN ( 
             SELECT LOWER(nome)
               FROM localita
            )


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •