Security
Connecting to DBs in Owl Web
Multi-Tenant

Easier Rule Examples

Cross-Table (Guided). Use our wizard to do ad-hoc analysis and visual setup.

Join Example Example (vs. cross-table guided seen above).

Multi-part condition rules with the rule builder. Combines profiling metrics & builder in one screen.

In-Clause (Single Column)

select * from @table1 where id
not in ( select id from @table2 )

Except (Multi-Column)

select id, app_id, email, guid_num from @table1
EXCEPT
select id, app_id, email, guid_num from @table2

Join Example

SELECT
*
FROM
@table1 A
LEFT JOIN @table2 B ON A.id = B.id
where
B.id is null OR (A.email != B.email)

Sample Results