Hi All, what would be the best way to write a query to pull all orders and order lines including standard and custom fields (body, column fields)?

something like

select * from transactionlines where type = ordertype