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

2015-09-23 Thread 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

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

2015-09-23 Thread 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

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

2015-09-22 Thread ChingChang Hsiao
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

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

2015-09-22 Thread ChingChang Hsiao
select * from service_table a,service_fib_table b where a.service_no=b.service_no; In this statement, the entry of service_fib_table must be existing to get the service_table and service_fib_table data. How can I write in one statement to get the service_table data no matter what the entry

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

2015-09-22 Thread Richard Hipp
On 9/22/15, John McKown wrote: > On Tue, Sep 22, 2015 at 3:15 PM, ChingChang Hsiao < > ChingChang.Hsiao at overturenetworks.com> wrote: >> >> How can I write in one statement to get the service_table data no matter >> what the entry of service_fib_table is existing or not. >> > > SELECT * FROM

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

2015-09-22 Thread John McKown
On Tue, Sep 22, 2015 at 3:15 PM, ChingChang Hsiao < ChingChang.Hsiao at overturenetworks.com> wrote: > > > select * from service_table a,service_fib_table b where > a.service_no=b.service_no; > > In this statement, the entry of service_fib_table must be existing to get > the service_table and