Hello, This is similar to my post earlier...(I'm really racking my brains over this). I'm going to try and rephrase (shorten) my question:
I've created a database that multiple users can search from. The results that USER1 returns must be unique even if USER2 uses the exact same lookup. So, I'm trying to put a "HOLD" on a record(s) that each USER is looking at, I'm trying to use TABLEB for indicating whos looking at what (who has a hold on certain records). I'm really hoping there is an efficient SQL approach to this, I'm trying to avoid using script to step painlessly through the tables record for record to apply HOLDS on records. Any good ideas? Karl --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
