MySQL does not enforce foreign key relationships.
So while I believe you can still do a natural/automatic join, the
fieldnames and datatypes must match.
-----Original Message----- 
From: Carlo Loiudice 
Sent: Fri 11/9/2001 5:11 PM 
Subject: [PHP-DB] Automatic JOIN

        Pardon, another question:
        Is there a way to say to Mysql to automatically detect
        a relation between 2 table and perform the join
        operation when there's a SELECT query ?
        I Hope this isn't a stupide question! But I've seen
        that in the detested MS Access, there a simple way so
        make a visual join between a field in a table with
        another field in another table.
        When there's a select on the 1st table, access
        automatically open the linked table and fetch the
        corresponding field.
        How to make this in mysql?
        Carlo, again
        Abbonati a Yahoo! ADSL con Atlanet!
        Naviga su Internet ad alta velocità, e senza limiti di tempo!
        Per saperne di più vai alla pagina
        PHP Database Mailing List (
        To unsubscribe, e-mail: [EMAIL PROTECTED]
        For additional commands, e-mail: [EMAIL PROTECTED]
        To contact the list administrators, e-mail:

Reply via email to