Search:

debasisdas, great link again

Thanks for such a great explanation

nice and helpfull answers

pulkit007 thanks for this tip, looking for something like that for a while

SQL - Structured Query Language

I am doing something similar, very helpful answers here.

debasisdas, thank you very much for thoose links

I prefer NOT IN

and create a relation between keys

What if I want to select emplyees who have same country but they need to have different city?

Also two or more foreign keys can give you primary key.

Hm it is hard to tell....

Thanks for all the answers, I am solving the same problem.

Aren't primary keys always generated?

select department_ID, max(employee)
from department

I guess, maybe if you would give us more info, it will be easier