Many thanks Peter. That's the definition I was after.
Kerry
-Original Message-
From: Peter K AGANYO [mailto:[EMAIL PROTECTED] Behalf Of Peter K AGANYO
Sent: 19 February 2007 00:35
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: SELECT single row from 2 tables
It sounds to me like you're needing to use a left outer join on t2.
Give that a shot instead of the inner join you're currently using.
Cheers,
-bemansell
On 2/17/07, Kerry Frater [EMAIL PROTECTED] wrote:
I am trying to select a particular row from a table and include a column for
aq second
I am trying to select a particular row from a table and include a column for
aq second table but I cannot get the result I am after.
I have table1 with 1000 rows and table2 with 12 rows. The relationship
between the tables is a column linkedfield. Table1 has a unique key called
lookup
If I use