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
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
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
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
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
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
6 matches
Mail list logo