select

• vascris

  Valued Member

  Points: 65

  More actions

  March 26, 2002 at 3:31 pm

  #101106

  How can i write a select from (select ) ??

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2002 at 4:52 pm

  #426136

  You mean a subselect

  SELECT collist FROM (

  SELECT collist FROM tableX WHERE conditions

  ) AS subSelTable

  Which this is a bad example. Please be more specific about what you are trying to do for more help.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)