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, only registered users may post in this forum.

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.