Hi,
For estabilish the relationship you have to type the same same
sql command what you fire from other RDBMS like oracle.Only the
command prompt is mysql> in plance of sql>.
For more detail go to www.mysql.com and read documentations.
Thanks,
Anjani
-Original Message-
From: Otoniel Ca
If I understand you correctly, you probably want to look into "left
joins". I.e.
select a.field, b.field from table1 a left join table2 b on
a.id=b.tbl1.id
vs
select a.field, b.field from table1a, table2 b where
a.id=b.tbl1.id
The first will show matching rows from table1 even
