Est. Budget: $50.00
Only for those who are proficient with SQL Server meta data.
We have a SQL Server database with a relational database structure.
You can assume that each table has a primary key on a single column (so no multi column primary key)
We need an algorithm that takes the following input parameters:
- @pk_field_name (of table @table_name1)
- @pk_field_name (of table @table_name2)
The algortihm should produce the following outcome:
FROM @table_name1 ON
INNER JOIN @table_name2
NULL if ...