Hi Everybody,
Question from a novice
I have 2 tables:
1. tblUsers
Fields: UserId, UserName, FromIP, ToIP, Country
User ID is PK (unique); FromIP and ToIP are the IP addresses in notation (123.28.47.227) etc. defining the network range of users.
2. tblSessions
Fields: IP, Sessions
What I'm trying to do is create a view that will show the following info:
UserId, UserName, Sessions
i.e. it will match the tblSessions.IP field with the tblUsers.FromIP & tblUsers.ToIP by a 'BETWEEN' Clause...
Question from a novice
I have 2 tables:
1. tblUsers
Fields: UserId, UserName, FromIP, ToIP, Country
User ID is PK (unique); FromIP and ToIP are the IP addresses in notation (123.28.47.227) etc. defining the network range of users.
2. tblSessions
Fields: IP, Sessions
What I'm trying to do is create a view that will show the following info:
UserId, UserName, Sessions
i.e. it will match the tblSessions.IP field with the tblUsers.FromIP & tblUsers.ToIP by a 'BETWEEN' Clause...