What is the difference between natural join and equi join?



What is the difference between natural join and equi join?..

Answer / Deepak Aswal

Both natural join and equi join are used to combine two or more tables in Sybase, but they differ in how they match records. Natural join matches records based on all common columns between the tables without any specific condition, while equi join requires an equal (=) condition to be specified for matching.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

What is trace flag definitions in sybase?

1 Answers  


How do you check database space? What measures are there to increase the db space?

1 Answers  


Sybase 12.5 Database Statistics (Maximum)

1 Answers  


What is this tds protocol in sybase?

1 Answers  


What are the main differences between 11.x and 12.x versions of sybase?

1 Answers  


What is a natural key in sybase?

1 Answers  


How to manually drop a table in sybase?

1 Answers  


How do I set ts role in order to run certain dbccs?

1 Answers  


Explain locking. List its types.

1 Answers  


What is open client in sybase?

1 Answers  


How do I make isql secure in sybase?

1 Answers  


How do I create a database in sybase central?

1 Answers  


Categories