[sqlite] get the data anyway no matter what the entry of the second table is existing or not

[R.Smith]

On 2015-09-22 11:17 PM, ChingChang Hsiao wrote:
> SELECT * FROM service_table AS a
> LEFT JOIN service_fib_table AS b ON a.service_no=b.service_no ;
>
>
> How about adding one more further conditional JOIN in one statement above.
>
> service_fib_table.fib_id=service_fib_port_table.fib_id
>
> It means there is a hierarchy 
> service_table->service_fib_table->service_fib_port_table.

Add as many as you like...

SELECT * FROM service_table AS a
LEFT JOIN service_fib_table AS b ON a.service_no=b.service_no AND 
a.species=b.species AND b.class='Donkey' AND a.points < b.points;