How to write sql query

Question

I have 3 table table A B C. A table have requestid those present in B C table . however I didn't get unique record . because in C table I have 3 record with same in the C table . in that table C two same column from here how to get unique record .
can someone help here . I want data from all table but unique data.

Answer 1

You can use online tools

https://www.tutorialspoint.com/execute_sql_online.php

http://rextester.com/l/sql_server_online_compiler

https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in

Answer 2

thanks I will try

Answer 3

Pandurang Ekhande, if you reply with your database structure maybe is better to try to help you ;-)

Answer 4

can you help me how to attach the attachment so I can explain you structure of table

Answer 5

You must to copy/paste code here in a post

Answer 6

While maybe you share your code, you could investigate about JOIN and/or INNER JOIN

Answer 7

I have already use that join but not working . I am not able to attach IMG of structure

Answer 8

No, you must to copy/past text code.

If you are working in a online server maybe you can share image by web url.

Answer 9

@Pandurang have you done something about your problem?

Answer 10

yes I have solve it . I have taken it at sequence I'd and sort out it

Answer 11

Excellent, maybe is a good idea you post the solution ;-)