Equality Joins - Revision history

Bacchas at 23:05, 23 October 2017

2017-10-23T23:05:00Z

← Older revision		Revision as of 23:05, 23 October 2017
Line 38:		Line 38:
	*The USING clause can be used only if the tables being joined have a common column with the same name. This rule isn’t a requirement for the ON clause.		*The USING clause can be used only if the tables being joined have a common column with the same name. This rule isn’t a requirement for the ON clause.
	* A condition is specified in the ON clause; this isn’t allowed in the USING clause.The USING clause can contain only the name of the common column.		* A condition is specified in the ON clause; this isn’t allowed in the USING clause.The USING clause can contain only the name of the common column.

			[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 23:02, 23 October 2017

2017-10-23T23:02:45Z

← Older revision		Revision as of 23:02, 23 October 2017
Line 25:		Line 25:
	FROM publisher p JOIN books b		FROM publisher p JOIN books b
	USING (pubid)		USING (pubid)

			SELECT c.lastname, c.firstname, b.title
			FROM customers c JOIN orders o USING (customer#)
			JOIN orderitems oi USING (order#)
			JOIN books b USING (isbn)
			WHERE category = 'COMPUTER'
			ORDER BY lastname, firstname;



	'''There are two main differences between using the USING and ON clauses with the JOIN keyword:'''		'''There are two main differences between using the USING and ON clauses with the JOIN keyword:'''
	*The USING clause can be used only if the tables being joined have a common column with the same name. This rule isn’t a requirement for the ON clause.		*The USING clause can be used only if the tables being joined have a common column with the same name. This rule isn’t a requirement for the ON clause.
	* A condition is specified in the ON clause; this isn’t allowed in the USING clause.The USING clause can contain only the name of the common column.		* A condition is specified in the ON clause; this isn’t allowed in the USING clause.The USING clause can contain only the name of the common column.

Bacchas at 22:57, 23 October 2017

2017-10-23T22:57:55Z

← Older revision		Revision as of 22:57, 23 October 2017
Line 25:		Line 25:
	FROM publisher p JOIN books b		FROM publisher p JOIN books b
	USING (pubid)		USING (pubid)
			'''There are two main differences between using the USING and ON clauses with the JOIN keyword:'''
			*The USING clause can be used only if the tables being joined have a common column with the same name. This rule isn’t a requirement for the ON clause.
			* A condition is specified in the ON clause; this isn’t allowed in the USING clause.The USING clause can contain only the name of the common column.

Bacchas at 22:56, 23 October 2017

2017-10-23T22:56:29Z

← Older revision		Revision as of 22:56, 23 October 2017
Line 21:		Line 21:
	AND category = 'COMPUTER'		AND category = 'COMPUTER'
	ORDER BY lastname, firstname;		ORDER BY lastname, firstname;

			SELECT b.title, pubid, p.name
			FROM publisher p JOIN books b
			USING (pubid)

Bacchas at 18:59, 22 October 2017

2017-10-22T18:59:45Z

@@ Line 12: / Line 12: @@
    AND o.order# = oi.order#
    AND oi.isbn = b.isbn
   ORDER BY lastname, firstname;

Bacchas at 18:54, 22 October 2017

2017-10-22T18:54:14Z

← Older revision		Revision as of 18:54, 22 October 2017
Line 6:		Line 6:
	AND (b.cost < 15 OR p.pubid = 1)		AND (b.cost < 15 OR p.pubid = 1)
	ORDER BY title;		ORDER BY title;

			SELECT c.lastname, c.firstname, b.title
			FROM customers c, orders o, orderitems oi, books b
			WHERE c.customer# = o.customer#
			AND o.order# = oi.order#
			AND oi.isbn = b.isbn
			ORDER BY lastname, firstname;

Bacchas at 18:44, 22 October 2017

2017-10-22T18:44:03Z

← Older revision		Revision as of 18:44, 22 October 2017
Line 1:		Line 1:
	'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins but are also referred to as equijoins, inner joins,		'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. '''
	or simple joins.		'''These joins are called equality joins but are also referred to as equijoins, inner joins, or simple joins.'''
			SELECT b.title, b.pubid, p.name
			FROM books b, publisher p
			WHERE b.pubid = p.pubid
			AND (b.cost < 15 OR p.pubid = 1)
			ORDER BY title;

Bacchas: Created page with "'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins..."

2017-10-22T18:29:17Z

Created page with "'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins..."

New page

'''The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins but are also referred to as equijoins, inner joins,
or simple joins.