[alfie romeo]

Hello

I got the same problem trying to link two tables.

here is table 1) jokes.authors:

Column Information For – jokes.authors

---

Field Type Null Key Default Extra

---

---

---

---

---

---

ID int(11) PRI (NULL) auto_increment

Name varchar(255) YES (NULL)

Index Information For – jokes.authors

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment

---

---

---

---

---

---

---

---

---

---

authors 0 PRIMARY 1 ID A 5 (NULL) (NULL)

DDL Information For – jokes.authors

---

Table Create Table

---

---

authors CREATE TABLE `authors` (

`ID` int(11) NOT NULL auto_increment,

`Name` varchar(255) default NULL,

PRIMARY KEY (`ID`)

TYPE=InnoDB

here is table two jokes.emails:

Column Information For – jokes.emails

---

Field Type Null Key Default Extra

---

---

---

---

---

---

ID int(11) PRI 0

EMail varchar(255) YES (NULL)

AID varchar(10) YES MUL (NULL)

Index Information For – jokes.emails

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment

---

---

---

---

---

---

---

---

---

---

emails 0 PRIMARY 1 ID A 2 (NULL) (NULL)

emails 1 Foreign 1 AID A 2 (NULL) (NULL)

DDL Information For – jokes.emails

---

Table Create Table

---

---

emails CREATE TABLE `emails` (

`ID` int(11) NOT NULL default '0',

`EMail` varchar(255) default NULL,

`AID` varchar(10) default NULL,

PRIMARY KEY (`ID`),

KEY `Foreign` (`AID`)

TYPE=InnoDB

I'm trying to get field AID in jokes.emails to read ID in jokes.authors. I'm a novice so not too sure.

many thanks

[alfie romeo]

thanks for your help

i'll investigate further.

[Author]

Posts