Yes, they look like this:
SELECT InvoiceLine."TxnDate", InvoiceLine."RefNumber", InvoiceLine."ShipAddressAddr1", InvoiceLine."ShipAddressCity", InvoiceLine."ShipAddressState", InvoiceLine."ShipAddressPostalCode", InvoiceLine."PONumber", InvoiceLine."SalesRepRefFullName", InvoiceLine."ShipDate", InvoiceLine."InvoiceLineItemRefFullName", InvoiceLine."InvoiceLineDesc", InvoiceLine."InvoiceLineQuantity", InvoiceLine."InvoiceLineRate", InvoiceLine."InvoiceLineInvoiced", Customer."FullName", Customer."BillAddressCity", Customer."BillAddressState", Customer."Phone", Customer."Contact", Customer."CustomerTypeRefFullName", ItemInventory."AverageCost", ItemInventory."CustomFieldAffilLicensingGroup", ItemInventory."CustomFieldBarCode", ItemInventory."CustomFieldCategory", ItemInventory."CustomFieldSize", ItemInventory."CustomFieldState", SalesOrderLinkedTxn."TxnDate", SalesOrderLinkedTxn."RefNumber" FROM (("InvoiceLine" LEFT OUTER JOIN "Customer" ON "InvoiceLine"."CustomerRefListID"="Customer"."ListID") LEFT OUTER JOIN "ItemInventory" ON "InvoiceLine"."InvoiceLineItemRefListID"="ItemInventory"."ListID") LEFT OUTER JOIN "SalesOrderLinkedTxn" ON "InvoiceLine"."TxnID"="SalesOrderLinkedTxn"."LinkedTxnTxnID" |