mysql> desc sender
-> ;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| SenderID | varchar(20) | YES | | NULL | |
| SenderName | varchar(30) | YES | | NULL | |
| SenderAddress | varchar(50) | YES | | NULL | |
| SenderCity | varchar(50) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.04 sec)
mysql> create table recipient(RecID varchar(20),
-> SenderID varchar(20) REFERENCES
-> [Link],
-> RecName varchar(50),
-> RecAddress varchar(50),
-> RecCity varchar (50));
Query OK, 0 rows affected (0.47 sec)
mysql> insert into sender values ('ND01','[Link]','2 ABC Appts','New Delhi');
Query OK, 1 row affected (0.06 sec)
mysql> insert into sender values ('MU02','[Link]','12 NewTown','Mumbai');
Query OK, 1 row affected (0.06 sec)
mysql> insert into sender values ('MU15','S jha','27/A,Park Street','Mumbai');
Query OK, 1 row affected (0.07 sec)
mysql> insert into sender values ('ND50','T Prasad','122-K,SDA','New Delhi');
Query OK, 1 row affected (0.06 sec)
mysql> insert into recipient values('K005','ND01','R Bajpayee','5 Central
Avenue','Kolkata');
Query OK, 1 row affected (0.10 sec)
mysql> insert into recipient values('ND08','MU02','S Mahajan','116 A vihar','New
Delhi');
Query OK, 1 row affected (0.04 sec)
mysql> insert into recipient values('MU19','ND01','H Singh','2A Andheri
East','Mumbai');
Query OK, 1 row affected (0.05 sec)
mysql> insert into recipient values('MU32','MU15','PK Swamy','B5 CS
Terminus','Mumbai');
Query OK, 1 row affected (0.08 sec)
mysql> insert into recipient values('ND48','ND50','S Tripathi','13 Mayur
Vihar','New Delhi');
Query OK, 1 row affected (0.04 sec)
select * from sender where sendercity='mumbai';
mysql> select [Link],[Link],[Link],[Link],[Link]
-> from recipient R, sender S
-> where [Link]=[Link];
mysql> select*from recipient order by recname;