Use Two Foreign Keys & Two Local Keys with hasMany Relation

Maybe something like this:

class Test extends Model
{
    public function questions()
    {
        $this->hasMany(Question::class, 'course_id', 'course_id')
            ->whereColumn('questions.subject_id', '=', 'tests.subject_id');
    }
}

I get this error Facade\Ignition\Exceptions\ViewException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tests.subject_id' in 'where clause' (SQL: select * from questions where questions.course_id = 1 and questions.course_id is not null and questions.subject_id = tests.subject_id)

In your question you said your table looked like this:

Tests |id|name|description|course_id|subject_id|

Is your table name Tests or tests?

The error says that there is no column subject_id. So either your column name is wrong or the table name?

The Table name is tests.

& i have used the exact code which you had suggested

Sorry I've overlooked something in your question but this might be the solution:

$questions = $test->course->questions()->where('subject_id', '=', $test->subject_id)->get();

So here, is ->course a relation method?

Yes, course should be a relation on your Test model:

public function course()
{
    return $this->belongsTo(Course:class, 'course_id', 'id');
}

And the course hasMany questions:

class Course extends Model
{
    public function questions()
    {
        $this->hasMany(Question::class, 'course_id', 'course_id');
    }
}