Hi Richard,
try this
SELECT
DISTINCT
p.poster_id AS has_posted,
t.id,
t.subject,
t.poster,
t.posted,
t.last_post,
t.last_post_id,
t.last_poster,
t.num_views,
t.num_replies,
t.closed,
t.sticky,
t.moved_to
FROM
topics AS t ,
I'm having some performance problems with queries looking like the
following:
SELECT DISTINCT p.poster_id AS has_posted, t.id, t.subject, t.poster,
t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views,
t.num_replies, t.closed, t.sticky, t.moved_to
FROM topics AS t
LEFT JOIN posts AS
On Sunday 01 February 2004 04:06 pm, Demitri Muna wrote:
> Hello,
Hi, Demitri -
> I need to embed a database into my application, and was referred to
> SQLite. I narrowed down my options to it and PostgreSQL (which I am not
> completely sure I can embed into an app). One thing that I need to be
>
3 matches
Mail list logo