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