Page 1 of 1

[Solved] Find departments E-104 or E-102 in database

Posted: Thu Jun 06, 2024 12:33 pm
by jerc9024
I am unable to execute database Query code can any one write me the code to find the department 'E-104' OR 'E-102' in my Data base :?:

Re: I am unable to execute database Query code....

Posted: Thu Jun 06, 2024 3:22 pm
by Sliderule
jerc9024 wrote:
I am unable to execute database Query code can any one write me the code to find the department 'E-104' OR 'E-102' in my Data base

Code: Select all

SELECT 
   "YourDatabaseTableName".* 
FROM "YourDatabaseTableName" 
WHERE "YourDatabaseTableName"."YourFieldName" IN ( 'E-104', 'E-102' )
I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.