This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Incorta Community
- Product
- Product Ideas
- I want to use empty or null as a condition in a jo...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Masaru_Asano
Cosmonaut
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
04-29-2025
09:40 PM
Status:
New
Currently, I don't think it is possible to set the following conditions using Incorta's join filter.
SELECT * FROM A
inner join B on A.column1 = B.column1
AND B.column2 is not null
AND B.column2 <> ''
Of course, you can exclude null or blank columns in advance using the where statement of the parent table, but there are cases where you may want to retain this data when looking at the table alone.
If you can set this condition using a join filter, you will be able to join with the intended conditions without having to add a separate table or MV, which will be convenient.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
