about join
Answers were Sorted based on User's Feedback
Answer / mala yadav
select command is used to fetch the result from the table ,
but of u want the combine results from more than 1 table
then in this case we use JOINS rather than a single table
select statement.
In joins u can join upto 2 to 61 tables to get tha required
result.
joins are of 5 types
- inner join
- self join
- cross join
- left outer join
- right outer join
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vishal
if u donot know join means u always working in one table but
always single table is not enough to give the result than
comes the concept of joins in which two table we join must
have a column same on the basis of the table are join. join
are of various type such as left outer, right outer ,inner
join etc
Is This Answer Correct ? | 0 Yes | 0 No |
How do you connect MySQL database with PHP?
What sql does mysql use?
Is mysql relational database?
What are the nonstandard string types?
How database are managed?
What is the difference between timestamp and datetime in mysql?
What is dump in mysql?
Why do we use the mysql database server?
How do I run mysql?
What is a join in mysql?
How to connect html form to mysql database using php?
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 Answers E2 Solutions, Tesco,