I'm trying the following query with no luck:
SELECT B.id AS BookId, P.id AS PdfId FROM tbl_Books AS B
INNER JOIN tbl_PDF AS P ON P.FileName = B.ShortName || '.pdf'
COLLATE NOCASE
Is in Sqlite possible to use a clause in ON statement?
Thanks
Sqlite ON statement on calculated field failing
73 Views Asked by MaiOM At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in SQLITE
- How to store a date/time in sqlite (or something similar to a date)
- How to copy data from SQLite to postgreSQL?
- When using a Room database on an Android application, is it possible to pre-populate data
- Expo Error - Android sqlite no such table
- how can debugg field id error in the database schema?
- How add array of authors for unique user in database in Goland IDE?
- Calculate SMA_Close10 and SMA_Close20 of minute data
- Transitioning from Static to Dynamic Data in React with Express Backend
- In SQLite, how to group ranges of values and sort the groups
- Issue with making python executable with local db, sqlite3, tkinter
- Calculating EuclideanDistance in SQL for Deepface facial embeddings?
- Problem with a simple query script used in RS Forms on Joomla 4
- Checking multiple user inputs to multiple fields in a sqlite3 database with python
- How to make that each seller has its own different set of products using sqlite and uwp
- peewee: SQLite - peewee Create() is forcing integer in PrimaryKeyField if leading character is numeric (even if there is a non-numeric in the middle)
Related Questions in INNER-JOIN
- Why is my merge returning more rows than I expected?
- How to join multiple tables effectively SQL
- SQL: join of 3 select queries from the same table (inner join and left join)
- Row_Number Function With PARTITION BY and joining with another table - Oracle SQL
- select row if NOT EXISTS condition after joining tables
- Join 2 panda data frames consisting of different indexes - getting Nan
- Understanding the similarity between INNER JOIN and CROSS JOIN in MySQL without conditions
- MongoDB Join filter, input, as, if, eq _id exists
- MySQL Inner Join with subquery
- SQL connect 2 tables and show latest date
- PySpark broadcastjoin
- How to properly utilize a composite index in JOIN queries?
- SQL - select multiple minimum values
- BigQuery is not running my JOIN IN code, returning error `Unrecognized name: employees at [10:3]`
- WHERE with several ANDed conditions filters as expected but using just one of them unexpectedly returns all rows
Related Questions in STRING-CONCATENATION
- How can i find every instance of a repeating string in a list, and then concatenate it to the list element that precedes it in every instance?
- R function `paste` is inverting the order of its arguments
- How to to concat multiple ranges views
- Concatenating Multiple Rows Into String
- How to Replace String Concatenation with JavaScript DOM Methods Properly
- Can you concatenate some, but not all, entries of a Pandas Series using str.cat when using a search string to iterate over a different column?
- FutureWarning: Support for nested sequences for 'parse_dates' in pd.read_csv is deprecated. How to combine date and time columns with pd.to_datetime?
- Merge an array of concatenated columns in Excel
- Why does my project not build when I try to import it to Eclipse?
- Why doesn't python concatenate string literals with adjacent string variables?
- Concatenate a char* to a string
- parseInt() function is adding 1 to my integer, and thus changing the number. What is going on?
- Can I reference concatenated columns in another column during the same INSERT?
- Google Spreadsheet - M2M Concatenator
- String concat based off empty cells below and across
Related Questions in ON-CLAUSE
- bad performance of postgres query if on-clause of inner-join is positioned after following left-joins
- Null result from multiple left Join in postgresql
- Why doesn't this work with an ON clause, but does with a WHERE clause?
- SQL Left Join with WHERE clause SAS Enterprise Guide
- How can I remove subquery?
- INSERT INTO with subquery and ON CONFLICT
- MySQL join two tables based on a condition
- Error Number: 1054 Unknown column '2021-08-23' in 'on clause'
- SQL JOIN in PostgreSQL - Different execution plan in WHERE clause than in ON clause
- HQL query for Collection using ON clause
- MYSQL adding OR clause in left join slowing up the query
- Predicate Pushdown vs On Clause
- CI and in the join on
- subquerying in WHERE/Joining 3 tables, 2 for records and one for number, returns no result/fails - MSAccess
- Teradata - Adding preceding zero and casting as varchar(50)
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I think what you need is
coalesce(b.ShortName, '.pdf'). Be aware, though, that it will return empty string ifb.ShortNameis an empty string (as opposed tonull).