[Help]Query to Dbo.account/Login

[unnamed123a]

I'm in need of a query for those two tables... I wanted to make the Dbo.account column "UserID" the same as the Dbo.Login column "UserID". I wanted the accout to be the same as login. The AID's are following below:

Could someone please setup this query for me?

Thanks

[MentaL]

[Hakurah]

Haven't tested this... Let me know if it works.

USE [GunzDB]

SET ANSI_NULLS ON
GO

INSERT INTO Login (UserID)
SELECT DISTINCT UserID FROM Account