What is inner join in sql server 2000?

1 answer

Answer

1026622

2026-04-20 07:20

+ Follow

Inner join refers to the join where records that match the where condition in both tables are only fetched.

Ex:

SELECT A.field1, A.field2, B.field3, B.field4 FROM Table1 A, Table2 B

WHERE A.field1 = B.field3

This is an inner join.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.