create table users ([uid] INT PRIMARY KEY IDENTITY(1,1), name nvarchar(100))
create table balance(bid INT IDENTITY(1,1) PRIMARY KEY, [uid] INT, dr FLOAT, cr FLOAT, FOREIGN KEY ([uid]) REFERENCES users([uid]))
GO
insert users ([Name]) values ('Haider'),('Ali')
GO
insert balance ([uid],[cr],[dr]) values (1,1000,null),(1,null,3000),(1,1000,null),(2,2000,null),(2,1000,null),(2,null,500)
GO
select * from users
select * from balance
GO
I Want Output Like This...
UID Name Balance
1 Haider 1000
2 Ali -2500
Thanks Advance <3
No comments:
Post a Comment