I have 2 Table Vend01 and Vend02:
In Vend01 I have Phone and Phone1 amount other filed (I do not have PhoneTypeid in this table)
Phone means Home's Phone Number (People knows by experience)
Phone1 means Office's Phone Number (People knows by experience)
In Vend02 I have Phone and PhoneTypeID
PhoneTypeID = 1000 means Office's Phone Number
PhoneTypeID = 1001 means Home's Phone Number
Phone means Phone Number Depends on the PhoneTypeID
I need update Phone's Field and PhoneTypeID in Vend02 from Vend01 depending on the criteria that Vend01.Phone means Home's Phone Number(People knows by experience) and Vend01.Phone1 means Office's Phone Number(People knows by experience)
All fields from Vend01 are up to date.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…