View Single Post
Old Oct 2, 2007 | 09:43 AM
  #8  
Pete's Avatar
Pete
Civilian
 
Joined: Jun 2003
Posts: 8,407
Likes: 1
From: Miami Beach. FL
Default

Originally Posted by Grifter
SELECT (employee.emp_fname ||' '|| employee.emp_lname) Pilot,
is pilot an alias?
Yes.

Originally Posted by dieneverknowing
Is 'emp_num' the correct column name under the employee table?
Yes.

Don't know if you guys can see it, but here is the database structure:

Attached Images
File Type: gif
ERD.gif (65.9 KB, 62 views)

Last edited by Pete; Oct 2, 2007 at 09:47 AM.
Reply