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

Discuss the database features
Post Reply
jerc9024
Posts: 5
Joined: Wed Jun 05, 2024 6:24 pm

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

Post 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 :?:
Last edited by MrProgrammer on Mon Jun 17, 2024 9:23 pm, edited 2 times in total.
Reason: Edited topic's subject
OpenOffice 4.1.15 on Windows 11
User avatar
Sliderule
Volunteer
Posts: 1290
Joined: Thu Nov 29, 2007 9:46 am

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

Post 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.
Post Reply