Conditional Join possible in SQL Server 2005? -

I have to write a specific question which adds to the tables based on condition (in this case, the basis of one of the values On the table) I would like to do something like this:

  Tablebed on table aner from SELECT * (tables column 1 = tablebay column 1 or table A. column 1 = 0) - Does not work!  

It should get what you need:

  SELECT * to table A. where A. Column 1 = 0 or the current (selection B. Column B. to B.B column 1 = A column 1);