Re: [sqlite] inner join problem

> update dzhhq set mnote= > case when mnote in (select mnote from dzhhq inner join (select bs,stkcode > from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote > else mnote > end > is ok, but when I use this cmd then appear error msg: > update dzhhq set mnote= > case when mnote in (sele

[sqlite] inner join problem

update dzhhq set mnote= case when mnote in (select mnote from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote else mnote end is ok, but when I use this cmd then appear error msg: update dzhhq set mnote= case when mnote in (select mnote from dzh

Re: [sqlite] Inner join problem

I once posted about that on this mailing list and one of the solution Mr DRH suggested was to auto-expand the table name ( would become SELECT * FROM ) internaly in the SQLite API, but I have no idea if any efforts were put in that direction since it could probably break the old syntax. Ce fut un

Re: [sqlite] Inner join problem

Sweet... works right perfect. Can it be considered as a bug? Merci beaucoup! Guille Simon Berthiaume wrote: I think I know what the problem is. SQLite doesn't like having a table name following an openint parenthesis "(" in the FROM clause. Try the following statements instead: SELECT main.id,

Re: [sqlite] Inner join problem

I think I know what the problem is. SQLite doesn't like having a table name following an openint parenthesis "(" in the FROM clause. Try the following statements instead: SELECT main.id, prim.primname, sec.secname FROM main INNER JOIN sec ON main.se

[sqlite] Inner join problem

Hi, I've had problems with inner join transactions. Here is what I do: I create the tables: sqlite> create table main ( ...> id integer primary key, ...> primid int(10), ...> secid int(10) ...> ); sqlite> sqlite> create table prim ( ...> primid integer primary key, ...> primnam