Create ODBC Dataset From Two Tables
When creating a new dataset, I am having trouble using any kind of join in the SQL. I am using ODBC and want to create a dataset that, for example, combines Invoice Header and Invoice Detail information. Do I need to create each of those as their own dataset and then do a transform, or can I do it all at once in one…
