Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 help me in thisplz anyone here

Author  Topic 

faysal
Starting Member

7 Posts

Posted - 2007-12-03 : 07:02:32
actaully i have a table in which i have
ammount
subacc
description
date

columns.....and i have an another table in which have

ammount
subacc
description
dedit
credit
company

in this i wanted the same values as i have put in the above one table....


how this will be done...............plzzzzzzzzzzzzzz tell me that one...........

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-03 : 07:04:37
What do you want to put in credit and company columns in second table? Are these columns Nullable? Are there any defaults on these two columns?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-03 : 07:23:29
If I understand what you are after, I think you may want to look up INNER JOIN.
Go to Top of Page
   

- Advertisement -