Welcome to WebmasterWorld Guest from 54.161.181.156

Forum Moderators: open

phpmyadmin innerjoin

   
8:25 pm on Aug 27, 2013 (gmt 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?
 

Featured Threads

Hot Threads This Week

Hot Threads This Month