So I have to do a join thank you ```LEFT JOIN Items ON Trans NetSuite Professionals #suiteanalytics

So I have to do a join, thank you! ```LEFT JOIN I...

Lincecum

06/16/2020, 4:06 PM

So I have to do a join, thank you!

Copy code

LEFT JOIN Items
ON Transaction_lines.item_id = Items.item_id
Where items.type_name != 'Shipping Cost Item'