Our Training Programs

All contents are copyright of their authors.

Login query

Carlos kambui

11yAsked May 28, 2015, 9:07 AM1.4kSQL

help me to solve this i want to check staff_login_code,branch_id,staff_password i have the below query ,kindly help

select * from staff where staff_login_code='',branch_id= and staff_password=

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Pankaj Kumar Choudhary11y ago
Hello @Carlos your query is not clear as per my understanding you can use this query
Select staff_login_code,branch_id,staff_password from staff where // put your condition here

you can visit this site
http://dba.stackexchange.com/questions/35165/selecting-data-from-multiple-rows-into-a-single-row http://www.sitepoint.com/forums/showthread.php?369291-SQL-Selecting-multiple-records-using-WHERE-function
Pankaj Kumar Choudhary11y ago
Hello @Carlos your query is not clear as per my understanding you can use this query
Select staff_login_code,branch_id,staff_password from staff where // put your condition here

you can visit this site
http://dba.stackexchange.com/questions/35165/selecting-data-from-multiple-rows-into-a-single-row
Gowtham Rajamanickam11y ago
http://stackoverflow.com/questions/9181775/sql-query-for-selecting-multiple-records
Gowtham Rajamanickam11y ago
http://www.sitepoint.com/forums/showthread.php?369291-SQL-Selecting-multiple-records-using-WHERE-function
Carlos kambui11y ago
help to write querry to select three items
Carlos kambui11y ago
kindly help on how to write such query not validating branch_id=
Rajeesh Menoth11y ago
Hi Carlos kambui,

Question is not clear,Carlos kambui are you facing any error ?