answersLogoWhite

0

Join query are basically of three types : 1) Cross Join -- That is use to retrieve data from two tables on a condition (optional), there we get m*n no. of records(m is no of rec in first table and n is the no. of records in another table) 2) Inner Join : we use this join to retrieve values from two tables that satisfies given matching condition : as :: select Product_Category from Product_Detail INNER JOIN Product_Scenerio ON Product_Detail.Product_Id = Product_Detail.Product_Id. Product_Scenerio . 3) Outer Join : this is used in three way: a) Left Outer Join -- it is used to retrieve records from both tables that satisfies given condition including all records from left(First) table whether it do not satisfy condition ...try it practically ** related columns in right table has NULL values in records b) Right Outer Join :: It is used when we want to fetch all records from right(second) table whether that do not match with condition specified with JOIN . ** related columns in right table has NULL values in records c) Full Outer Join :: It is combination of Inner join + left Outer join + right Outer join .Here we get all records from both tables that do not match condition .

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Engineering

What is the difference between QBE and SQL?

Query by Example (QBE) is a database query language for relational databases. A QBE parser parses the search query and looks for the keywords. A more formal query string, in languages such as SQL, is then generated, which is finally executed. However, when compared with a formal query, the results in the QBE system will be more variable.SQL (Structured Query Language) SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs


What is Object Query Language OQL?

OQL is a database query language(related to ODMG) that is based on SQL and supports the adding, retrieving, querying, and invocation of objects. OQL is a version of the Structured Query Language. A object query language that supports complex data types such as multimedia, spatial, compound documents, etc., that are stored as objects. Standard SQL queries can still be used, and the OQL server process converts the objects into relational views. Sanjay


What is the full form of SQL in computer?

Structured Query Language


Do you need sql and c plus plus to code in them in Visual Studio?

Connect to a SQL Server, query with Transact-SQL (T-SQL), and view the results with the mssql plugin for Visual Studio Code. The SQL Database projects extension for VS Code comes with the mssql extension, which supports SQL projects on Windows, macOS, and Linux. To learn more about data science please visit- Learnbay.co


What is the programming language does enovia use?

It's JAVA based on the front end with Html and Javascript for the web interface. The backend can be either Oracle or SQL Server 2005/2008 -- with SQL Server 2008 being be better performance over Oracle on the same hardware and lower cost.

Related Questions

What is syntax errors in sql server 2005?

wrong sql syntax in your query


What does the acronym SQL stand for?

SQL stands for Structured Query Language as it refers to the type of database query or database server which accepts the query.


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


How do you find the users are connected to sql server 2005?

Use the query "sp_who" or "sp_who2" to get the users of the server where sp_who2 fetches the records with time.


Diff between sql server 2000 and sql server 2005?

Hi Everybody, I am Vijay.According 2 me the differences are: 1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio. 2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype 3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.


Describe IDE of SQL Server 2005?

An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts


When was SQL Server Management Studio created?

SQL Server Management Studio was created in 2005.


What are the main function in sql?

SQL (Structured Query Language) is a language used in a SQL server to manage data (Query the data, insert, Update, Delete) as well as perform data manipulation (calculations, etc)


Definition of cross join in sql server?

Cross Join is jsut another Join


How do you find port number of a sql server?

In SQL Server 2005/2008 : Sql Server Configuration Manager -> Protocols -> TCP/IP -> IP Addresses -> TCP Port. In SQL Server 2000 : Client Network Utility -> Select 'TCP/IP' from the enable protocols list and press 'Properties' button. The default port is 1433.


What has the author Louis Davidson written?

Louis. Davidson has written: 'Pro SQL Server 2005 Database Design and Optimization' 'Pro SQL server 2008 relational database design and implementation' -- subject(s): Client/server computing, SQL server 'Pro SQL Server 2005' 'SQL Server 2000 Stored Procedures Handbook (Expert's Voice)'


From sql server 2000 and sql 2005 which one is best?

It's a long list check this website: http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/