I am really driving myself nuts over this easy problem. Imagine that I am doing a simple join on two tables:
SELECT e.firstname, j.job_name
FROM Employee e, Jobs j
WHERE e.job_id = j.job_id
The problem is that if a record in the Employee table has no job_id (a feasible case in my situation), obviously that record will not be returned. Ideally, I would want the record returned whether or not a corresponding job_id exists, possibly returning "" if the job_id doesn't exist.
I really feel like I am missing some common knowledge, so any help is great.