Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

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