question

somdeepgniyogi avatar image
somdeepgniyogi asked

Sql query help

![alt text][1] [1]: /storage/temp/2605-capture.png Please help
sql-server-2008homework
capture.png (35.0 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What have you tried so far? I think you should make an attempt before you ask other people to do it for you.
0 Likes 0 ·
I tried to union the tables, but it is returning all the rows with duplicate rows...
0 Likes 0 ·
David Wimbush avatar image
David Wimbush answered
I think you need to select from Reference left join Results.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

somdeepgniyogi avatar image
somdeepgniyogi answered
Thanks a lot.. Your suggestion helped a lot
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

baijumohan avatar image
baijumohan answered
select company, cluster, desc, amount from reference left join Results on (reference.cluster= results.cluster)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.