Using JOIN

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  August 10, 2006 at 8:06 am

  #103215

  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

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  August 10, 2006 at 8:43 am

  #654336

  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