There are created Table “A” and “B” in “TestDb” database.
Below Query will fetch records using INNER JOIN.
SELECT * FROM A INNER JOIN B ON A.ID=B.Id
Output :
Below Query will fetch records using LEFT JOIN.
SELECT * FROM A LEFT JOIN B ON A.ID=B.Id
Output :
Below Query will fetch records using RIGHT JOIN.
SELECT * FROM A RIGHT JOIN B ON A.ID=B.Id
Output :
Below Query will fetch records using FULL JOIN.
SELECT * FROM A FULL JOIN B ON A.ID=B.Id
Output :
Below Query will fetch records using CROSS JOIN.
SELECT * FROM A,B
Output :
49 records will be retrieved.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.