Join two tables without matching columns

Question

1.00/5 (2 votes)

See more:

Hi Everyone,

I have a list of Currencies in one Table.

TABLE A:

Currency
--------
Pound
Dollar
Yuan

Then I have list of Users in another Table.

TABLE B:

User
----
ABC
XYZ

Can I do I join of some sort on Table A and B to get the following result.

RESULT:

User | Currency
--------------
ABC | Pound
ABC | Dollar
ABC | Yuan
XYZ | Pound
XYZ | Dollar
XYZ | Yuan

I have tried joins, but they need a field to compare. In this care there is none.

Please help.

Posted 28-Jun-14 21:46pm

kasbaba

Updated 16-Feb-21 14:37pm

Add a Solution

4 solutions

Solution 2

If the server does not support CROSS JOIN syntax, you may use the following:

SQL

SELECT a.User, b.Currency FROM TableA a, TableB b

Posted 30-Jun-14 0:01am

Sergey Vaselenko

Solution 4

Why do you required to write query without matching column .... ?

Posted 30-Jun-14 0:37am

Manoj Kumar Choubey

Solution 3

Try this,

SQL

Select * from Table A, Table B

Posted 30-Jun-14 0:08am

Magic Wonder

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kasbaba · Accepted Answer · 2014-06-28T22:28:00

Solution 1

Okay - I got it working.

Stupid not to try it in the first place.

SELECT User,Currency FROM TableA CROSS JOIN TableB

Posted 28-Jun-14 22:28pm

kasbaba