Using JOIN
-
Hello I want to do a query with 3 tables and use the JOIN command. What is the syntax for 3 tables?
The tables are:
sys.tables, sys.triggers abd sys.schemas
David
Best Regards,
~David
-
Got it.
SELECT *
FROM
sys.triggers t JOIN sys.tables a ON t.[parent_id] = a.[object_id]
JOIN sys.schemas s ON a.[schema_id] = s.[schema_id]
WHERE t.[Name] = 'TR_AIUD_CC_CUSTOMER_DELTA_A' AND a.[Name] = 'CUSTOMER' AND s.name = 'CRM'
Best Regards,
~David
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply