Liveware Publishing Support Forum

I am using SQL tables, not database files. Another option that I also cannot figure out is joining a constant to the value of a key field in the table to be joined without actually joining the master table. For example, I would like to only join a table with the name "Column1" with the con...

I have a table that has week numbers in the field name (columns): wk01, wk02, ... ,wk52 and another column that houses the current processed week number with rows referenced by a key. I need to be able to take the number from the current week column and reference the associated week column name. For...

Is it possible to join two tables from two different databases? We have our data stored in separate databases than our client^s data and need to create reports that access both sides. When I try to join the SQL databases, I can only access the database where the default table lies. I have both datab...