Sql query help

Question

question

somdeepgniyogi asked Jul 14, '15

![alt text][1] [1]: /storage/temp/2605-capture.png Please help

sql-server-2008 homework

capture.png (35.0 KiB)

2

10 |1200

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

David Wimbush commented · Jul 14, 2015 at 10:33 AM

What have you tried so far? I think you should make an attempt before you ask other people to do it for you.

0 ·

somdeepgniyogi commented · Jul 14, 2015 at 10:39 AM

I tried to union the tables, but it is returning all the rows with duplicate rows...

0 ·

Answer 1 · 2015-07-14T10:43:13Z

David Wimbush answered Jul 14, '15

I think you need to select from Reference left join Results.

10 |1200

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

Answer 2 · 2015-07-14T10:50:16Z

somdeepgniyogi answered Jul 14, '15

Thanks a lot.. Your suggestion helped a lot

10 |1200

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

Answer 3 · 2015-07-14T11:45:47Z

baijumohan answered Jul 14, '15

select company, cluster, desc, amount from reference left join Results on (reference.cluster= results.cluster)

10 |1200

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