This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know if UNION ALL works in SuiteQL? Getting HTTP 500 once I merge two queries together that way

Separately they are fine, trying to not have to build custom ETL work for this and I can just use the UNION ALL to move on with life

Yeah I made a really basic test and UNION ALL doesnt work
```select
id,itemid 
from item
where id = 10

union all

select
id,itemid 
from item
where id = 11```
This is not my exact SQL, just a mockup of what i'm doing

UNION ALL is supported. However, there are some strange aspects of the Item and Transaction tables that can cause issues...

If you add an additional filter to the where clauses on the queries, and specify an item type, you might have some luck.