I know that i am not specifying any ORDER BY clause, but i saw, in
general, that this is the default behaviour in other databases system
This was just an example query but i was just wondering if the table
may be corrupt or i can have some problems on the database or this is
normal.
It's totall
Hi,
i have a table and i noted that if i do a query like "select * from
table" i get the data from this table not ordered by primary key (the
primary key field is not auto increment).
I know that i am not specifying any ORDER BY clause, but i saw, in
general, that this is the default behaviour
> Is it possible to rewrite this as a top-level join, without using a subquery?
>
> Something along the lines of:
>
> SELECT em.end_item_meter_id
> FROM end_item_meter em
> inner join Meter_Reading mr
> on em.end_Item_meter_id = mr.end_item_meter_id
> INNER JOIN End_Ite
-- This is the real query (with subquery)
SELECT em.end_item_meter_id
FROM end_item_meter em
WHERE em.end_Item_meter_id IN
(
SELECT
mr.end_item_meter_id
FROM
Meter_Reading mr
Hi Knut
Thanks, that was the trick to use !
François
> -Original Message-
> From: kristian.waa...@sun.com [mailto:kristian.waa...@sun.com]
> Sent: Tuesday, November 10, 2009 7:32 AM
> To: Derby Discussion
> Subject: Re: How to connect derby by python
>
> Zhang Qian wrote:
> > Hi,
> >
> > I have to access derby DB with my python script, but
Zhang Qian wrote:
Hi,
I have to access derby DB with my python script, but I do not know if
there are any python modules for this purpose I can use.
Any suggestions will be really appreciated!
Hi Qian,
What about using Jython :)
There's an article describing how to connect to Python using
Hi,
I have to access derby DB with my python script, but I do not know if there
are any python modules for this purpose I can use.
Any suggestions will be really appreciated!
Regards,
Qian
