InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:48:09 GMT20http://www.sqlservercentral.com/Forums/Topic549240-146-1.aspx[font="Verdana"][quote][b]GSquared (8/8/2008)[/b][hr]You can put anything you'd put in a Where clause, into a join clause. Some things might be a bad idea, but you can technically do it.[/quote]but if we analyze its impact on performance then it may not be bad idea at all?what u suggest by your expertise ?Focus in Performance only![/font]Wed, 16 Jun 2010 04:08:38 GMTAbrar Ahmad_http://www.sqlservercentral.com/Forums/Topic549240-146-1.aspxYou can put anything you'd put in a Where clause, into a join clause. Some things might be a bad idea, but you can technically do it.Fri, 08 Aug 2008 08:58:26 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic549240-146-1.aspx[quote][b]sanjeev_krs2004 (8/8/2008)[/b][hr]Hi can we do add OR or AND in INNER and OUTER joins conditions..? if anybody has any clue, please reply.[/quote]Yes, you can. The following (absolutely useless in terms of the result) query shows it:[code]select c.namefrom sys.objects as o join sys.columns as c on o.object_id = c.object_id OR ( (o.object_id = c.object_id AND o.object_id = 4) )[/code]Regards, AndrasFri, 08 Aug 2008 08:42:57 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic549240-146-1.aspxHi can we do add OR or AND in INNER and OUTER joins conditions..? if anybody has any clue, please reply.Fri, 08 Aug 2008 08:29:54 GMTsanjeev_krs2004