I am sure this is simple but... 1

[jshurst]

I am trying to write a simple query.
Example:

select animalid, citizenid from animal
where cageid = 4

The citizenid is also a primary key in a Citizen table. If this is not NULL then I would like to be able to return a firstname, and lastname from the citizen table (I really don't care anything about returning the citizenid - just the names). Can someone help me here? Thanks.

 

[r937]

select animalid
     , firstname
     , lastname
  from animal
left outer
  join citizen
    on animal.citizenid
     = citizen.citizenid
 where cageid = 4

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[jshurst]

Wow, that was a bit more complicated than I thought. I'm kinda new to SQL and have never used an outer join before. Looks like I need to do some reading. Thanks.

 

[ks2000]

Good Luck..... BOL is the best tool to read.

Good Luck
Gopala Krishna Kakani