How to do cross join in sq self join l?

Question

2.00/5 (1 vote)

See more:

i have table in sql i want to cross join or self join

SQL

Name          Value1       
jim            100           
jak            50
stiv           25

expected result

SQL

Name value1  
Jim   100 
Jim   50
Jim   25
jack  100
jack  50
jack  25
stiv  100
stiv  50
stiv  25

What I have tried:

still i am working on it ,and i could like know what is the best method to achieve this

Posted 11-Jul-16 19:44pm

murkalkiran

Updated 17-Jul-16 21:31pm

Add a Solution

Comments

Tomas Takac 12-Jul-16 3:10am

What have you tried so far? Show your code.

Suvendu Shekhar Giri 12-Jul-16 3:13am

That's pretty easy to do.. Share what have you tried so far.

3 solutions

Solution 2

SQL

Select t1.name,t2.value from myTable t1, myTable t2

Posted 11-Jul-16 21:15pm

The hellraiser

Updated 11-Jul-16 21:17pm

v3

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)

ProgrammingEnthusiast · Accepted Answer · 2016-07-17T21:31:00

Solution 4

SQL

SELECT        t.name, t1.value
FROM            Table_1 AS t CROSS JOIN
                         Table_1 AS t1
ORDER BY t.infoID

Posted 17-Jul-16 21:31pm

ProgrammingEnthusiast

Anisuzzaman Sumon · Accepted Answer · 2016-07-11T21:15:00

Solution 3

Just write the query

SQL

SELECT  b.NAME, a.Value1
    FROM Table_1 a, Table_1 b

I assumed that your table name is Table_1

happy coding! :)

Posted 11-Jul-16 21:15pm

Anisuzzaman Sumon

Comments

Anisuzzaman Sumon 20-Jul-16 9:21am

I could not understand why did someone give me down vote?