Text Join Vs Left Outer Join

[SibaP]

What is the difference between Left Outer Join Vs Text Join ?

I know Text Join is a language dependent but LOJ is not, apart from this, anything else ?

[venkateswaran_k]

Left Join

To get the information about orders to our customers table, regardless of whether a customer placed an order or not, we would use a left join. A left join returns all records from table A and any matching records from table B.

Important to note when use left join, make sure you put bigger table on left side (example customer)

Text Join

I do not know...

Inner Join

To get the information about orders to our customers table, only for the customer placed an order, we would use a inner join. A inner join returns only records from table A and matching records from table B