MySQL Forums
Forum List  »  Newbie

Select table within a table and update column based on initials and surname
Posted by: John Biddulph
Date: May 29, 2018 05:36PM

I have 3 tables, tblclients (userid), customer (where I’d like to search on initials and surname) and then to update the newCustomerID in the Servicescopy table, I started the sql query but I’m getting a bit lost, please help?!

Select * from tblcontacts tc
Inner join (select * from servicescopy sc)
On tc.userid = sc.CustomerID)

Select * from customer c where tc.company = c.initials + c.surname

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.