joins in Database

Author Topic: joins in Database  (Read 21716 times)

Offline Brackwom

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 30
  • Karma: 0
Re: joins in Database
« Reply #10 on: 09-10-2021, 07:23:05 »
SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS. if we can join two tables that will reduce the number of rows needed to be processed by subsequent steps, then our performance will improve.


Offline jackharry11

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 1
  • Karma: 0
    • Hexon digital
Re: joins in Database
« Reply #11 on: 07-19-2022, 00:13:27 »
There are different types of joins like inner join, outer join, self join
newbielink:https://hexondigital.ca/digital-branding-services-vancouver/ [nonactive]


Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 171
  • Karma: 0
    • F1removals.co.uk
Re: joins in Database
« Reply #12 on: 07-30-2022, 08:43:00 »
There are different types of joins like inner join, outer join, self join, cross join, natural join, equi join, non-equi join.
 :D
Can you explain it to me in detail.

Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 171
  • Karma: 0
    • F1removals.co.uk
Re: joins in Database
« Reply #13 on: 08-08-2022, 12:19:46 »
Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table

Offline f1dark

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 0
  • Posts: 105
  • Karma: 0
  • Gender: Female
  • F1 Removals is the top removals company in the UK,
    • F1removals.co.uk
Re: joins in Database
« Reply #14 on: 08-13-2022, 07:30:37 »
There are different types of joins like inner join, outer join, self join,


Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 171
  • Karma: 0
    • F1removals.co.uk
Re: joins in Database
« Reply #15 on: 08-19-2022, 11:58:44 »
Following are types of SQL joins:-
Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table
 !-!
really wn informative post  !-!

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
5403 Views
Last post 06-23-2015, 00:53:38
by Talukdar
0 Replies
2789 Views
Last post 12-22-2015, 00:15:35
by chinmay.sahoo
0 Replies
1828 Views
Last post 11-21-2016, 03:38:33
by aarav
6 Replies
9121 Views
Last post 08-12-2022, 09:34:15
by f1dark
4 Replies
29935 Views
Last post 08-26-2022, 05:25:06
by dark404