Join 2 unrelated tables

• Charlottecb

  Hall of Fame

  Points: 3932

  More actions

  April 28, 2005 at 5:47 am

  #67685

  Hi All (SQLserver 2000)

  I have 2 unrelated table (tblStaff and tblModule) as follows: -

  tblStaff

  1  Fred

  2  John

  3  Sarah

  4 Jack

   

  tblModule

  Module1

  Module2

  Module3

  I need to return a result set as follows

  1  Fred Module1

  1  Fred Module2

  1  Fred Module3

  2  John Module1

  2  John Module2

  2  John Module3

  3  Sarah Module1

  3  Sarah Module2

  3  Sarah Module3

  4  Jack Module1

  4  Jack Module2

  4  Jack Module3

  The tables have no relationship between them. I need to code this as part of a Stored Proc.

  Thanks

  CCB

• Charlottecb

  Hall of Fame

  Points: 3932

  More actions

  April 28, 2005 at 6:00 am

  #555486

  Ignore the previous post. Have sussed it.

  CCB