I have an access data base with three tables named DD, Export , and RPL I have the result of a inner join betweent EXPORT AND DD which is working fine Now with those results I want to update a third table RPL which is currently empty but has those fields to be populate for example RPL.[Hotel ID] should be
COUNT(field) return 0 if it doesn’t exist
Sounds like a simple thing to do, but I’m struggling with it and probably over thinking it. I’m basically trying to figure out if a category, and what category that is, that is missing a Job value in …
SQL Server – Use substring in where clause
I’m trying to come up with a query in which it’s going to filter based on a substring. The substring operation is working fine if I use it as a select statement, but not when I try to use it for …
Creating a new column using the result set from union all – sql
I have TWO simple VIEWS with columns PID and NAME respectively. Here’s how they are connected to each other. View1: PID NAME Comp1 , C1 Comp2 , C2 View2: PID NAME ParentPID …
Getting count depending on subquery
In my SELECT statement below, I’m looking to get a COUNT of connections from a table, where connections are defined as 1 connection per unique transactionID. Thus, in my COUNT, I want to check to make …
SQL Query to Select Min and Max Values For Each Day Over a Period
I would like to select all the rows that contain either min or max datetime values for each equipment_id, for every day included in the period. The code below selects the min and max datetime values …
Is it possible to select a distinct column and get another column’s value count? [closed]
I think I might know enough to do parts individually but is it possible to do it with one statement? I need to display a model count for each year it appears in. I have the following data: id model …
oracle: remove only blank lines
How to remove empty lines in sql or plsql Input select ‘test1 test2 test3 test4’ from dual; Expected output: test1 test2 test3 test4 TRANSLATE is removing all the new line character
What is the simplest way to put pass an array of values into a parameter of TVF
Objective: I would like to have a parameter in my function to allow the user to input a list of values. Ideally, the simplest solution … Note: I dont have permissions to create tables in dbs. …
MySQL – How to modify parent/child select query to add more children to existing array/JSON?
I have the following query working OK: SELECT core_condition AS name, NULL AS parent FROM condition_theme_lookup UNION ALL SELECT theme_name AS name, condition_theme_lookup.core_condition AS parent …