SELECT 
  Col1,
  Col2
FROM table1 a
  INNER JOIN table2 b
    ON a.id = b.id
      AND a.otherid = b.otherid
  INNER JOIN table3 c
    ON b.something = c.something
WHERE 
  a.Col1 = '15'
  AND b.ColX = 'Lumbago'

quote:

---

Originally posted by topdev

his approach would be like this:

SELECT T1.Data1
FROM Table1 T1
INNER JOIN Table2
INNER JOIN Table3
ON T1.Key=T2.Key
ON T3.Key=T2.Key

---

...
FROM TableA
    INNER JOIN
    (
        TableB
        INNER JOIN TableB_Child1
            ON B1_Col = B_Col
    )
        ON B_Col = A_Col

SELECT T1.Data1
FROM Table1 AS T1 
    INNER JOIN Table2 AS T2
        ON T2.Key=T1.Key
    INNER JOIN Table3 AS T3 
        ON T3.Key=T2.Key

SELECT T1.Data1
FROM Table1 T1 
    INNER JOIN Table2 T2 ON T1.Key=T2.Key
    INNER JOIN Table3 T3 ON T2.Key=T3.Key

SELECT T1.Data1
FROM Table1 AS T1 
    JOIN Table2 AS T2
        ON T2.PkKey1 = T1.Col1
       AND T2.PkKey2 = T1.ColN
       AND T2.IsActive = 1

SELECT [TheName] = SomeColumnOrExpression

SELECT SomeColumnOrExpression AS [TheName]

WHERE
    ...
    Col1 = Col2 AND
    Col3 = Col4 OR
    ...

WHERE
    ...
         Col1 = Col2
     AND Col3 = Col4
     OR ...
    ...

IF ( ... lots of stuff ) {
...
}

IF ( ... lots of stuff )
{
...
}

LEFT OUTER JOIN [XFS_ORel] obr_email
	  INNER JOIN [XFS_OTypeRel] obrt_email
		 ON obr_email.[OTypeRel_Id] = obrt_email.[OTypeRel_Id]
		 AND obrt_email.[OTypeRel_Name] = 'D2PC'
	  INNER JOIN [XFS_Object] obj_email
		 INNER JOIN [XFS_SourceType] st_email
			ON obj_email.[SrcType_Id] = st_email.[SrcType_Id]
			AND st_email.[SrcType_Location] = 'Email'


		 INNER JOIN [XFS_AttrLong] a_email
			INNER JOIN [XFS_AttrType] at_email
			   INNER JOIN [XFS_AttrCollection] ac_email
				  ON at_email.[AttrColl_Id] = ac_email.[AttrColl_Id]
				  AND ac_email.[AttrColl_Name] = 'BPC'
			   ON a_email.[AttrType_Id] = at_email.[AttrType_Id]
			   AND at_email.[AttrType_Name] = 'Name'
			ON obj_email.[Obj_Id] = a_email.[Obj_Id]
			AND a_email.[AttrValueNLongString] = 'FROM'

		 INNER JOIN [XFS_ORel] obr_sender
			INNER JOIN [XFS_OTypeRel] obrt_sender
			   ON obr_sender.[OTypeRel_Id] = obrt_sender.[OTypeRel_Id]
			   AND obrt_sender.[OTypeRel_Name] = 'PC2P'
			INNER JOIN [XFS_Object] obj_sender
			   INNER JOIN [XFS_SourceType] st_sender
				  ON obj_sender.[SrcType_Id] = st_sender.[SrcType_Id]
				  AND st_sender.[SrcType_Location] = 'Email'
			   ON obr_sender.[Child_Obj_Id] = obj_sender.[Obj_Id]

			INNER JOIN [XFS_AttrLong] a_sender
			   INNER JOIN [XFS_AttrType] at_sender
				  INNER JOIN [XFS_AttrCollection] ac_sender
					 ON at_sender.[AttrColl_Id] = ac_sender.[AttrColl_Id]
					 AND ac_sender.[AttrColl_Name] = 'BP'
				  ON a_sender.[AttrType_Id] = at_sender.[AttrType_Id]
				  AND at_sender.[AttrType_Name] = 'Name'
			   ON obj_sender.[Obj_Id] = a_sender.[Obj_Id]

			ON obj_email.[Obj_Id] = obr_sender.[Parent_Obj_Id]
		 ON obr_email.[Child_Obj_Id] = obj_email.[Obj_Id]
	  ON obj_doc.[Obj_Id] = obr_email.[Parent_Obj_Id]

quote:

---

...
That code is so ugly, I wouldn't go home with it if it was the last girl left at closing time.
...

---