Thanks a lot. Both works fine.
Leo
John Machin schrieb:
> On 27/05/2009 1:09 AM, Leo Freitag wrote:
>
>> Hallo,
>>
>> I got some problems with a select on a foreign key with value null.
>> I want to filter all male singers.
>>
>> CREATE TABLE 'tblsinger' ('id' INTEGER PRIMARY KEY, 'name' TEXT,
On 27/05/2009 1:09 AM, Leo Freitag wrote:
> Hallo,
>
> I got some problems with a select on a foreign key with value null.
> I want to filter all male singers.
>
> CREATE TABLE 'tblsinger' ('id' INTEGER PRIMARY KEY, 'name' TEXT,
> 'fkvoice' INTEGER, 'sex' TEXT);
> INSERT INTO "tblsinger" VALUES(
Hallo,
I got some problems with a select on a foreign key with value null.
I want to filter all male singers.
CREATE TABLE 'tblsinger' ('id' INTEGER PRIMARY KEY, 'name' TEXT,
'fkvoice' INTEGER, 'sex' TEXT);
INSERT INTO "tblsinger" VALUES(1,'Anna Netrebko',1, 'f');
INSERT INTO "tblsinger" VALUES(
2009/5/26 Leo Freitag :
> Hallo,
>
> I got some problems with a select on a foreign key with value null.
> I want to filter all male singers.
>
> CREATE TABLE 'tblsinger' ('id' INTEGER PRIMARY KEY, 'name' TEXT,
> 'fkvoice' INTEGER, 'sex' TEXT);
> INSERT INTO "tblsinger" VALUES(1,'Anna Netrebko',1,
4 matches
Mail list logo