How to write this select statement?

Question

If I have table1 contains Name, col2, col3 and table2 contains Name, NickName and col6.

I want to do select statement such I have a table like:

Name, NickName, col2, col3

where if table1 has 3 rows the new table should have the same.

Pepe · Accepted Answer · 2013-11-24 22:00:39Z

2

Updating to answer your question:

Try this:

WITH tbl2 AS (SELECT DISTINCT ON (Name) Name,Nickname FROM table2 ORDER BY Name)

SELECT tbl1.Name, tbl2.Nickname, tbl1.col2, tbl1.col3 FROM
table1 tbl1 INNER JOIN tbl2 ON tbl1.Name = tbl2.Name

Disclaimer: haven't tested this. Let me know if it works.

edited Nov 24, 2013 at 22:00

answered Nov 24, 2013 at 21:30

Pepe

6,4805 gold badges29 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aan Over a year ago

I think you mean ON instead of WHERE? Also, Imagine you have 1 row in table1 and 4 rows in table2, so will get more than one row when the condition table1.Name = table2.Name is satisfied.

Pepe Over a year ago

So how would you know which record to select from table2?! Do you just want the first match? This might cause interesting behavior.

Collectives™ on Stack Overflow

How to write this select statement?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related