<[EMAIL PROTECTED]> writes:
> SELECT
>o.name,o,contactname,o.contactphone,o.fax,o.emailaddy,o.freetelephone,o.address1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.price
> FROM user_wantads AS uw,organisations AS o,users AS u ,itemtypes AS
>i,itemmanufacturers AS m,provi
i actually found the problem,
SELECT o.name,o,contactname
should be
SELECT o.name,o.contactname
jeff
On Wed, 13 Jun 2001, Robby Slaughter wrote:
> What happens when you don't join quite so much? That is, take off the AND
> blah blocks,
> one by one?
> -Robby
>
> -Original Message-
Title: Getting a specific row from a table
My problem is that I want to pull to specific rows from a query result.
First here is the query:
SQL-query:
select card, status, time_stamp, comp_date
from test_record
where id = 45
order by card, comp_date
Next here is the result:
card
What happens when you don't join quite so much? That is, take off the AND
blah blocks,
one by one?
-Robby
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 3:38 PM
To: [EMAIL PROTECTED]
Subject: [SQL] large g
Hi
I have a largeish join that is giving me an error..
here's the query
SELECT
o.name,o,contactname,o.contactphone,o.fax,o.emailaddy,o.freetelephone,o.address1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.price
FROM user_wantads AS uw,organisations AS o,users AS u ,ite
I apologize in advance, 'cause I think this was addressed a couple of months
ago, but I cannot find it in the archives.
I have a firewall hit database which keeps the date of the hit and the
offenders IP (among other items). I would like to be able to execute a
select which would show each uniq
> "SR" == Srikanth Rao <[EMAIL PROTECTED]> writes:
SR> I have a linked list representing a tree. How do I
SR> store it in the database? Does PGSQL give us any
SR> special procedures to deal with such structures?
Pick up a data structures book and read up on how to implement a
linked list ins
