how to query::join two table, one table has no data and the other has some data!!???

• batista1331

  SSC Veteran

  Points: 206

  More actions

  November 20, 2008 at 9:15 am

  #124957

  How can I join two table (with a query) that, one table has no data and the other has some data!!???

  this is because some times my data base may have a table with or with out data.

  thanks

  I can't use:

  SELECT comp.NAME, car.ID

  FROM comp, car

  it returns an empty table...

• Max Yasnytsky

  SSCrazy

  Points: 2462

  More actions

  November 20, 2008 at 9:22 am

  #901120

  Is it LEFT JOIN you are looking for?

• batista1331

  SSC Veteran

  Points: 206

  More actions

  November 20, 2008 at 9:27 am

  #901124

  LEFT JOIN doesn't work!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 20, 2008 at 9:34 am

  #901132

  Double posted. See this thread for more info: http://www.sqlservercentral.com/Forums/Topic605904-169-1.aspx

  Please refrain from posting the same question in multiple forums. Most contributors watch all the forums.