Re: [ADMIN] Complex join query

2002-05-29 Thread Stephan Szabo
On Wed, 29 May 2002, Gareth Kirwan wrote: > Hello all, > Let's dive straight in, eh? > > 1. > Table: current_sessions > Fields: Server (int Foreign Key servers.id) > Client (int Foreign Key clients.id) > status (vc(10)) > > 2. > Table: clients > Fields:

[ADMIN] Complex join query

2002-05-29 Thread Gareth Kirwan
Hello all, Let's dive straight in, eh? 1. Table: current_sessions Fields: Server (int Foreign Key servers.id) Client (int Foreign Key clients.id) status (vc(10)) 2. Table: clients Fields: id (serial Pkey) username (UNIQUE) 3.