I have the following SuiteQL

( SELECT * FROM nexttransactionlinelink WHERE previoustype = 'SalesOrd' and nexttype = 'ItemShip' AND previousdoc IN ( SELECT ID FROM Transaction WHERE Type = 'SalesOrd' AND TranID = 'S12345' ) ) UNION ( SELECT ID, TranID FROM Transaction WHERE Type = 'SalesOrd' AND TranID = 'S12345' )

And what I want to get from this is basically two results grouped together - a list of sales orders found based on their transaction IDs, and a list of item fulfilments created off of those sales orders (ideally, I'd actually prefer to search the "createdFrom" field if possible, can I do this?) - but when I run the union in postman to test the query I just have an error returned. I know each query on its own works just fine, but for the sake of NetSuite concurrency limits, I'd like to just do this in one query if possible. Is there a way to do this? Edit: the reason I do "previousdoc IN" is because I will have a whole list of SO#'s that I'll want to map together and search for all SOs and their related IFs, but for this example I just use one SO

All queries in a union must return the same number of columns, and the data types must match.