Hi,
I'm fairly new to this database, and have read much discussion on
sub-queries. I've seen that they can be great for some queries, and
downright slow for others. I have a table with two foreign keys referencing
another table, like:
Table #1
employee_id (pk)
employee_name
Table #2
teamleader_employee_id
backup_employee_id
both fields in table 2 need to do a lookup in table 1 to get the name of the
actual employee. Do I need to use nested queries to accomplish this? Any
help is greatly appreciated!
-AM