On Tue, 23 Nov 2004, Roderick A. Anderson wrote:
Jaime Casanova wrote:
http://www.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-JOIN
Been there, done that. Bought several tee-shirts.
What do you mean with *complex joins*?
SELECT first, last, username || '@' || dom.domain as
Jaime Casanova wrote:
http://www.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-JOIN
Been there, done that. Bought several tee-shirts.
What do you mean with *complex joins*?
SELECT first, last, username || '@' || dom.domain as emailaddress
FROM cust_main cm
LEFT OUT
--- "Roderick A. Anderson" <[EMAIL PROTECTED]>
escribió:
> Be gentle as I come from an Oracle background a long
> time ago.
>
> I am trying to join several tables with a couple of
> tables having a one
> to many relationship. I got one query working
> pretty well but the issue
> comes about whe
Be gentle as I come from an Oracle background a long time ago.
I am trying to join several tables with a couple of tables having a one
to many relationship. I got one query working pretty well but the issue
comes about when I add one more table with a one-to-one relationship. I
get a semi/pseudo
On Mon, Nov 04, 2002 at 14:37:42 -0500,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> Can anyone tell me if there is any real difference between the two different ways to
>create tables joins?
>
> select field1, field2 from table1 join table2 using (field3)
>
> vs.
>
> select field1, field2 from t
lt;mailto:tachung_h@;yahoo.com>
> To: 'Jodi Kanter' <mailto:jkanter@;virginia.edu>
> Sent: Monday, November 04, 2002 2:44 PM
> Subject: RE: [ADMIN] joins
>
> I need to work with a group of volunteer developers over the Internet.
> Developers might be using W
Title: Message
I think this was meant for the list (see
below).
- Original Message -
From: tachung_h
To: 'Jodi Kanter'
Sent: Monday, November 04, 2002 2:44 PM
Subject: RE: [ADMIN] joins
I need to work with a group of volunteer developers
over the Internet. Developer
Can anyone tell me if there is any real
difference between the two different ways to create tables joins?
select field1, field2
from table1 join table2 using
(field3)
vs.
select field1, field2
from table1, table 2 where
table1.field3=table2.field3
Thanks
Jodi
__
