| |

VerySource

 Forgot password?
 Register
Search
View: 673|Reply: 1

* = Problems encountered when converting to LEFT OUTER JOIN

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 Vietnam

Post time: 2020-1-18 20:00:02
| Show all posts |Read mode
Questions are as follows:
My table A B is now outreach and they all have 3 columns COL1, COL2, COL3

The conditions at * = are
SELECT A. *, B. * FROM A, B WHERE A.COL1 + A.COL2 + A.COL3 * = B.COL1 + B.COL2 + B.COL3
How do I write a LEFT OUTER JOIN? Thank you!
Don't know if i understand
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-4-28 11:45:01
| Show all posts
Direct LEFT OUTER JOIN to see if it can be achieved
SELECT
  COL1
  FROM A LEFT OUTER JOIN B
     ON A.COL1 = B.COL1
       AND A.COL2 = B.COL2
       AND A.COL3 = B.COL3
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list