modify a new table name Table1 to include this condition:-
This new table has an attribute( which is a primary key ) and it takes the value of another attibute from another table. The name of both attributes are the same. Furthermore, it must take the value whose other attibutes of the other table to be NOT NULL.


Please advice

Thanks -- Eric_Singapore ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

Do some search on the concept of "Foreign key" online. What you seem to be
asking is nothing but a referential integrity constraint.

How can I check if it is currently executing?
Left Joins (*=)
Newbie question on BULK INSERT of text file
Multiple queries in stored procedure questions
Theory on composit key