query w/ two criteria

[jaYPee]

I'm having problem w/ my query on how to filter a record based on the
criteria i give.

here's the tables

students table
id
program

course table
courseid
id
program
course

for example if i have this data on my table

id students.program course.program course
1 BEED BSED FIL 2
2 BEED FIL 2
3 BEED ENG 2

based on the above example. if i want to query a course field = FIL 2
and if program = BSED the result should be:

id students.program course.program course
2 BEED FIL 2
3 BEED ENG 2

but if i query course field = FIL 2 and program = BEED the result
should be:

id students.program course.program course
2 BEED FIL 2
3 BEED ENG 2

the point here is that if course.program field is not empty the
criteria is based in course.program but if it is empty the criteria is
based on students.program.

hope i explained it well.

[jaYPee]

sorry i have some error on my previous post. here's the refine sample

I'm having problem w/ my query on how to filter a record based on the
criteria i give.

here's the tables

students table
id
program

course table
courseid
id
program
course

for example if i have this data on my table

id students.program course.program course
1 BEED BSED FIL 2
2 BEED FIL 2
3 BEED ENG 2

based on the above example. if i want to query a course field = FIL 2
and if program = BSED the result should be:

id students.program course.program course
1 BEED BSED FIL 2

but if i query course field = FIL 2 and program = BEED the result
should be:

id students.program course.program course
2 BEED FIL 2
3 BEED ENG 2

the point here is that if course.program field is not empty the
criteria is based in course.program but if it is empty the criteria is
based on students.program.

hope i explained it well.