Software Testing/Automation Testing Tutorials: Cross join with example

Sunday, 15 January 2017

What is cross Join ? Each row of first table will be joined with each row of second table.

Syntax :

Select table1.Column_Name1,table2.Column_Name1
from Table1
Cross join Table2

Consider the following two tables : Salary:

Employee_record:

Emp_id	Emp_city	Emp_lastname
01	noida	chauhan
02	gurgaon	singh

Query of cross join:

select *
from salary
cross join Employee_record

Result :

Emp_id	Emp_salary	Emp_desig	Emp_id	Emp_city	Emp_lastname
01	25000	Software Eng	01	noida	chauhan
01	25000	Software Eng	02	gurgaon	singh
02	30000	Senior Software Eng	01	noida	chauhan
02	30000	Senior Software Eng	02	gurgaon	singh
03	25000	Software Analyst	01	noida	chauhan
03	25000	Software Analyst	02	gurgaon	singh

Download & Install	Sample program to find greater no.	Boolean Operatot & Array	Java Object Class & Method with example
Singleton Class & Method in java with example	Method Overloading in Java with Example	Inheritance in java with example	Method overriding in java with example
Polymorphism in Java With example	Constructor, Super & this keyword in java	Encapsulation in Java with example	Abstraction in Java with example
Interface in Java with example	String in Java with example	toString() method in Java with example	Package in java with example
Exception Handling in java with example	Static keyword in Java with Example	Upcasting and Downcasting in Java	Swap two variable in java
Scanner class in java	Java 8 Stream Filter with Example	reverse the string in java without using functions	Sort the array without using Java functions
Difference between Final, Finally and Finalize in Java	for each loop in java with example	Hashmap in Java	How to find duplicate element in array
Difference Between Collection & Collections	Can we override static/private method	Data Structure in Java	Dictionary & serialization in java
How to Read & write Excel in Java	Collection Interface In Java	MultiThreading in Java	JDBC in JAVA
Reflection in Java	Constructor chaining in java	Wrapper Class in java	Loose Coupling and Tight coupling in java with example
POJO Class in Java with Example	How to Validate String is number in java	Get State Name by City name	Get State Name by City Name in India
Comparable and Comparator Interface in Java	Generics In Java

History of Selenium, Architecture	Practice Page	download Install Selenium & TestNG
Accessing WebElements In Selenium	Access basic Web elements	create xPath & Css path Manually
Pageobject Model in Selenium	Automate Firefox, chrome & IE	DATA Driven Framework
verify links on Webpage	keyword Driven Framework	Hybrid Driven Framework
Different Wait in Selenium	Take screen shot in selenium	HeadLess Browser testing in Selenium
Create WebDriver Instance for multiple class	scroll browser in Selenium	Send Reports Automatically to Email using Maven
Handle Frames in Selenium	Handle Tabs in selenium	Perform Right Click Action
How to upload file in selenium	How to get number of rows in html able	Listeners In TestNG
Read the tool tip text in selenium	How to press multiple keys in selenium	JavascriptExecutor usage in Selenium
Selenium Integration with AutoIT

Software Testing/Automation Testing Tutorials