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 ta
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
