You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Version = v9.12.1
On a single page I have 4 tables of the same structure (Team,Task, Description, Target). On the parent page to that I'm trying to write a query that merges all of them and filters by Target fields.
This is the query I'm using.
SELECT * FROM T* WHERE "Target" = "Q4"
The issue is the result "The query returned no rows." when I know one of the subtables has that value.
Hi @Nick Frazier ,
The first thing that caught my eye is "Target" = "Q4".
If you refer to a column, you use 'Column_name'.
If you refer to a string, you use "Some_string".
Seems that you should change your query as:
SELECT * FROM T* WHERE 'Target' = "Q4"