For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
You want to lock the three tables a, b and c, and issue the following statements:
mysql> LOCK TABLES a READ;
mysql> LOCK TABLES b READ;
mysql> LOCK TABLES c READ;
Which tables are now locked?
Isn't this exactly what you told the pivot table to do?
The two records can't be distinguished with the given values of startdate, hat and sipno.
You can add the starttime to the row edge and you should see the two rows.
Timo
Main problem here is i misunderstood pivot table's work principles. Thank you.