what is JOIN? Give example & types of join?

Answer Posted / santosh

joins are three types
equity join
natural join
conditional joins
these joins use to create conection b\w thie attributes

Is This Answer Correct ?    18 Yes 39 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

794


How do I flush privileges in mysql?

499


What is mysql community edition?

518


What is bigint in mysql?

518


How to enter numeric values as hex numbers?

537






What does mysql_query return?

502


What is difference between mysql and mysql workbench?

460


What is inner join in mysql?

473


What is the difference between primary key and candidate key?

510


How do I zip a file in mysql?

544


How many rows we can insert in a mysql table?

492


What is the purpose of using timestamp data type?

504


Is mysql an oracle product?

489


Is mysqli deprecated?

502


What is database engine in mysql?

495