SQL Statement needed

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RyanRandall SSChampion Points: 13623 More actions · Answer 1

Sounds like you need to use 'CROSS JOIN'...

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

robm1391 SSC Veteran Points: 215 More actions · Answer 2

anyone have an example of this?

I need to take two tables, two columns and have it output a third with all possible combinations.

RyanRandall SSChampion Points: 13623 More actions · Answer 3

Your google not working?

select *, fName + ' ' + lName as FullName from

(

select 'Fred' as fName union

select 'Wilma' union

select 'Barney' union

select 'Betty'

) as flintstones_1 CROSS JOIN

(

select 'Flintstone' as lName union

select 'Rubble'

) as flintstones_2

This was my starting point:

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.