questbahlin Red Ribbon

False

I decided to pivot away from using the orderLine table and am now using the transactionLine table. This is working perfectly over ODBC. transactionLine does have some caveats that orderLine did not - there's now multiple lines being returned per transaction.id. If I had to guess, they look like breakouts of GL Accounts…

Getting closer (maybe?)…the SQL error being reported has nothing to do with my joins or my syntax. Seems as though I cannot query the orderLine table via ODBC. Even this statement results in the same error I mentioned in OP: (where OrderID = a specific order in our system) select * from orderLine where orderLine.order =…

Sorry for the delay in updating! I've been tinkering with the permissions aspect. Adding the Wave table to the permissions doesn't seem to have any effect, I get the same error as before. I was thinking about this though - normally when I encounter a permissions error, I'll get an error message like this ("TableName" being…

Thanks Nicole for the idea! Looking into the permissions angle this morning, I'll let you know.

Just dropping by a year+ later to say thank you for posting this, this is super helpful! Thanks Donna :)