cross join

• lasheen_mail

  Newbie

  Points: 1

  More actions

  December 25, 2007 at 9:36 am

  #184972

  good morning

  I wanna to put a sub query in the cross join like that

  SELECT *

  FROM table1

  CROSS JOIN (select field

  from table2

  cross join table3)

  but i got this error

  Msg 102, Level 15, State 1, Line 7

  Incorrect syntax near ')'.

  can anyone help me!!!!

• David McFarland

  SSChampion

  Points: 11815

  More actions

  December 25, 2007 at 9:59 am

  #762615

  You need to alias your derived table.