bcp with multiple table queryout

• Zambrtp

  SSC Veteran

  Points: 257

  More actions

  July 24, 2003 at 7:12 am

  #82030

  Hi all:

  I have been successful in bcping out simple select statments using the queryout argument with one table and multiple columns.

  BUT I need to bcp out something liks this:

  select w.field, w.field, t.field. t.field from we w, test t where

  w.field = 0 AND t.field = 0

  when I do this the bcp fails ( this test from Analyzer)

  Can I not do multiple table statments. Ive read BOL, search web, forums it leads me to believe as long as its a valid statement it should work...HELP

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 24, 2003 at 11:12 pm

  #466964

  I tested a BCP queryout joining (PUBS) authors and titleauthor and it worked ok.

  I notice you have a syntax error in your query (t.field. t.field). Could that be the cause?

  
  Cheers,
  - Mark