The table size will be large that it may contain records in lakhs.
Method 1:
Tables:
Users ( UserID varchar(20) primary key, PassWord varchar(20))
UsersLogin(User ID varchar(20),Log inDate DateTime)
Query:
Select Users.UserID,Us ersLogin.LoginD ateMethod 2:
from Users U inner join UsersLogin UL
on Users.UserID = UsersLogin.User ID
Tables:
Users ( SysUserID Integer primary key,UserID varchar(20), PassWord varchar(20))
UsersLogin(SysU serID Integer, LoginDate DateTime)
Query:
Select Users.UserID,Us ersLogin.LoginD ateHere for the seccond method i made SysUserID additional which will be a system generated ID, and for joins which will give better performance.
from Users U inner join UsersLogin UL
on Users.SysUserID = UsersLogin.SysU serID