Re: how to join tables on multiple conditions for same column

2009-04-11 Thread Shawn Green
PJ wrote: I am trying to select names from a list which depends on another table for their ranking. I want to retrieve all names that start with a Capital letter in last_name and ranking of 1 and any other names that have a ranking of 2 but are both related to a third table. tables: book(id,...et

how to join tables on multiple conditions for same column

2009-04-05 Thread PJ
I am trying to select names from a list which depends on another table for their ranking. I want to retrieve all names that start with a Capital letter in last_name and ranking of 1 and any other names that have a ranking of 2 but are both related to a third table. tables: book(id,...etc.), author(