I am creating a job application portal using Codeigniter and MySQL. I have the following tables:

* jobs - which contains the list of jobs
* students - which contains the list of students
* jobs\_applied - which contains the applied jobs list by students

**jobs**
--------

primary key: `job_id`.

**columns: `job_id`, `job_name`**

**students**
------------

primary key: `student_id`.

**columns: `student_id`, `student_name`, `student_email`**

**jobs\_applied**
-----------------

primary key: `jobs_applied_id`.

foreign key: `job_id`, `student_id`.

**columns: `job_id`, `student_id`, `status`, `applied_date`**

In my app, when a user applies for a job then i change the status columns in `jobs_applied` to "pending". I want to remove the applied jobs from the list. 

So far, i am using the following query to list the jobs.

```
SELECT * FROM jobs

```

I have tried using `INNER JOIN` against the `jobs_applied`, but i am stuck in it. I don't know how to exclude it from the list. I have the `student_id` in my session. 

**How to create a query that excludes the jobs applied by the students using `student_id` as a condition?**