On Fri, 30 Oct 1998, Ulf Mehlig wrote:
> Unfortunately, I can't recommend a good book about SQL since I have
> read only the user manuals of the commercial database systems I had to
> work with; I know a rather theoretical textbook (Database System
> Concepts, H. F. Korth & A. Silberschatz, McGraw
You are right. Thanks.
Perhaps originally I used a query that only used the annex_log table, but
this app I'm writing is generating the queries and there's also a query
that does the same job but FOR groups and there I shall use all the three
tables. I store the parts of the query string in C cons
Sebestyén Zoltán AKA Memphisto wrote:
> select annex_log.username,
> annex_log.login_time,annex_log.bytes_in, annex_log.bytes_out
> from users, groups, annex_log
> where
> ppp_start >= date_trunc('day','1998 September 20'::datetime) and
> ppp_start < (date_trunc('day','1998 Sep
I've three tables:
groups(name text); -- This one contains name of usergroups
users (username text, groupid oid); -- This one contains name users,
-- groupid is a foreign key to "groups" table's oid.
In the following table, the username attribute is the same as in "users"
so "annex_log" is in 1-
