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

Hi Alan,
Thanks for the reply. Do you have an example you can share? Perhaps I'm using the wrong syntax but I was unable to append two queries I had.

union.sql

What sort of error are you getting?  If you can show the queries you are having trouble with, it might help with further narrowing down the problem.  Here is a simple example (just two columns) that works for me.

One thing I have noticed is that when I have a UNION in my SuiteQL, it does not like it if I have an ORDER BY statement at the end.  I'm not sure why, but if you are using ORDER BY, try removing that to see if it eliminates the issue.

you can wrap in an outter statement to get order by

select *
from
(
SELECT id, email FROM Contact	
UNION
SELECT id, email FROM Customer)
order by id asc