MySQL Forums
Forum List  »  Views

Re: Cannot edit data in view
Posted by: Kenny Holmes
Date: April 22, 2014 07:05AM

Hi,

I have not used the merge function before so please correct me if I am wrong. Doesn't the merge table join tables of matching structure, similar to the way that union does?

With my problem the data is cross referenced based on a key column. The table tblCompetitionSponsors is the table at the centre of a many-many relationship.

Unless I have missed something, the merge function does not look like the right solution for me.

Cheers

Kenny

Options: ReplyQuote


Subject
Views
Written By
Posted
4830
April 18, 2014 09:28AM
1521
April 18, 2014 12:09PM
Re: Cannot edit data in view
1501
April 22, 2014 07:05AM
1393
April 22, 2014 11:09AM
1511
April 23, 2014 09:28AM
1754
April 23, 2014 10:10AM


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.