SQL Server Combine TableA with many records with TableB with one record and no common field.

I have an email list table that I want to merge with a table containing email body content text.  How do I associate every record in the email list with the email body content record?

TableA contains 3 records first row is column name:
EMail                    FirstName        LastName
JoesEmail             Joe                     Smith
AnnsEmail            Ann                    Jones
MikesEmail          Mike                   Davidson

TableB contains 1 record first row is column name:
Information1          Information2                   Information3
Info1Text                Info2Text                         Info3Text

Desired output:
JoesEmail              Joe                Smith          Info1Text            Info2Text             Info3Text
AnnsEmail             Ann               Jones          Info1Text            Info2Text             Info3Text
MikesEmail           Mike             Davidson     Info1Text            Info2text             Info3Text
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
The above methods are technically obsolete.

The formal/ANSI term is "CROSS JOIN", like so:

FROM dbo.TableA

Note that "CROSS JOIN" doesn't allow an "ON" clause, since by definition a CJ joins every row from the left table to every row in the right table.
Guru JiCommented:
There is a simple statement for that

Select * from TableA, TableB

This will show you your desired output
There may be a difference in what you actually asked for and what you really need, but this is it.  :)

select A.EMail, A.FirstName, A.LastName, B.Information1, B.Information2, B.Information3
from TableA
join TableB
on 1=1
DBAduck - Ben MillerPrincipal ConsultantCommented:
Yes, CROSS JOIN is the way to accomplish this in a non-obsolete way.
lotterygirlAuthor Commented:
That is what I needed.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.