if you are looking for the connection string please findout here www.connectionstrings.com and to relate two or more tables you need to link them by primary key and refering foreignkeys.

try this


foreignkey (oid) references customer(cid)


as part of the 2nd table creation.

when you are posting such a questiln always post what you have tried so far to solve that . That will give us an idea on your exact requirment.

is your join proper ?

what you want to do with the tables ?

I am bit confused with your logic. Not sure what do you mean by that suspect.

If yo want to match for two conditions then you have to specify that in the sql query.

How can you develop a project only in sql server 2000 without using any front end tool.

Try to create the view using simple where clause for checking the PurchaseDescription field and change the other fields accordingly.

You simply need to join the tables to get the desired output. Try from your side and post the query that you have tried to get further clarification on the topic .

This problem is because you are trying to create two objects by same name. You are creating a column and a constraint by the same name with in a table . this why u are getting this error . Try to use...

what if the the table2 contains more/different columns than the table1 ?
you have to specify the column name
Your code will work if both the tabels are having same structure.

use the IN clause
or
simply write a procedure and pass the values. that u want to delete.