sql = "SELECT FirstName, LastName, Employeeid, ID FROM xyz WHERE location = '5'
order by LastName"

How do I change where it says where location='5' to show all the locations that are in database?
Location
5
6
7
8
9
10

Thank you,

Simple remove the WHERE clause

sql = "SELECT FirstName, LastName, Employeeid, ID FROM xyz
order by LastName"

OR

sql = "SELECT FirstName, LastName, Employeeid, ID FROM xyz WHERE location <> '0'
order by LastName"

Thank you but I think I was not clear.

When a user logs in with their username and password, they should only see the list of locations that are assigned to them deriving from the database

For example
Joe logins and should see only location 5 and 6 not all of them from the database.

Right now I am just using the following statement:
select firstname, lastname, employeenumber from xyz where WHERE location = '5' order by lastname

When the user logs in all he/she see is the location of 5 not 6, how can I go about showing the user both the locations they need to see. This also applies to other users that login and need to see their locations such as 10 or 12.



Thanks,

I did not know that lol this help me to thanks guys

You can use IN statement .... like SELECT * FROM TBL WHERE ID IN (1,2)