Lock Tables - Manual Ambiguity

Hi All, The 3.23.54 Manual states in; Section 1.4.4.3 Transactions If you only obtain a read lock (as opposed to a write lock), then reads and inserts are still allowed to happen. The new inserted records will not be seen by any of the clients that have a

Query Help Pls? - Better with 1 or 2 queries?

Hi, I am hoping you can help me please. The following query, while valid, returns me an Empty set. -- SELECT plan, cardNr, crdholdersName, cardType, cardExpDate, strAddr, townCity, stateProvince,