I have two tables A and B. Both tables are connected with SSN number as foreig

I have two tables A and B. Both tables are connected with SSN
number as foreign key. I want to retrieve a column data from B
table. How will you write a query?

Question Posted / shaikdada

3 Answers
8144 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / harsha

One can use Inner Join to get data from two tables.

Is This Answer Correct ?

4 Yes

1 No

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / siri

1)select ssn from b;
2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn
3)seelct b1.ssn from a a inner join b b1 on a1.ssn=b1.ssn

Is This Answer Correct ?

0 Yes

1 No

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / naidu sekhar yandrapu

SELECT SSN FROM B;

Is This Answer Correct ?

1 Yes

4 No

Post New Answer