Demirchyan, Wednesday, April 03, 2002, 10:16:53 PM, you wrote: DOA> Hello everyone, I have the following line in my create table code:
DOA> SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES DOA> SCAN_PARAMETER(SCAN_PARAM_ID) DOA> I need to make it so that scan_param_id references to two differences tables? Will this work? DOA> SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES DOA> SCAN_PARAMETER(SCAN_PARAM_ID) REFERECES SCAN_ACQUIRED_DATA (SCAN_PARAM_ID) Hm .. How do you see references on two different tables? As for me it doesn't make sense in relational database theory. For what do you need references on tow different tables? DOA> Thanks, DOA> Oganes Demirchyan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
