SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:49 AM
| ||||
| ||||
 Re: SELECT single row from 2 tables with WHERE clause 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 <kerry@myforefathers.co.uk> wrote: > 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 the code > SELECT t1.*,t2.thedescription AS t2desc FROM table1 AS t1, table2 AS t2 > where (t1.lookup='ZZZZZ') > I get a result of 12 rows (as expected) > > SELECT t1.*,t2.thedescription AS t2desc FROM table1 AS t1, table2 AS t2 > where (t1.linkfield=t2.linkfield) > I get 1000 rows as expected > > SELECT t1.*,t2.thedescription AS t2desc FROM table1 AS t1, table2 AS t2 > where (t1.lookup='ZZZZZ') and (t1.linkfield=t2.linkfield) > returns 1 row if there is an active link between the two tables and > > returns 0 rows if there isn't. > > This is where I am stuck. In the last example I would like the 1 row whether > there is an "active" link or not. The difference will be simply that the > "t2desc" rsulting column will be blank or contain a value. > > Can anyone help me with the logic? > > Kerry > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=l...rian@gmail.com > >      |
Linear Mode
