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 |
What are the ways in which you can retrieve data in the result set of mysql using php?
How we can get distinct columns values in mysql?
How to analyze tables with 'mysqlcheck'?
How to set the time zone for MySQL to particular country time?
How do I enable mysqli extension?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What is the difference between float and double?
What tools available for managing mysql server?
How many tables will create when we create table, what are they?
What is the use of mysqli_query?
please give me the answer for this: query which generates the second highest integer in the table?
How can we get the number of rows affected by query?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)