Welcome to WebmasterWorld Guest from 54.167.46.29

Forum Moderators: open

Message Too Old, No Replies

phpmyadmin innerjoin

     
8:25 pm on Aug 27, 2013 (gmt 0)

New User

joined:June 24, 2013
posts: 27
votes: 0


Here's my problem, I would like to use phpmyadmin to perform an innerjoin using like.
Here's the beginning of the code:

UPDATE homeowners10 INNER JOIN homeowners
ON homeowners.Last_Name = homeowners10.last AND Homeowners.Address = homeowners10.address
SET homeowners10.email = homeowners.email
The problem is that in ontable the address is spelled last part of the address is spelled out (Court) in the other it is abbreviates (Ct).

Can this be done with phpmyadmin? If not can you tell me how to do it programmatcially with php?
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members