Hi all.

My three tables in the db MYSQL:

Code:
TBL_MASTER
ID	TYPE
1	RG
2	CO
3	RG
4	RG
5	RG
6	CO
7	CO


TBL_RG
ID	ID_MASTER
1	1
2	3
3	4
4	5


TBL_CO
ID	ID_MASTER
1	2
2	6
3	7
Whit this query I see the rows in the tbl_master and in the tbl_rg:

Code:
   
   SELECT * FROM 
      tbl_master 
   INNER JOIN 
      tbl_rg ON 
         tbl_rg.ID_MASTER = tbl_master.ID

I need see the rows of the tbl_co with same and only query SQL... it's possible?

Can you help me?
kind regards
viki