hi, thats the first time I am a bit confused by a query not working.
I have this table: gullevek=# \d test Table "public.test" Column | Type | Modifiers ---------+-------------------+-------------------------------------------------------- test_id | integer | not null default nextval('test_test_id_seq'::regclass) email_a | character varying | email_b | character varying | Indexes: "test_pkey" PRIMARY KEY, btree (test_id) with this content: gullevek=# select * from test; test_id | email_a | email_b ---------+---------------+------------- 2 | [EMAIL PROTECTED] | [EMAIL PROTECTED] 1 | [EMAIL PROTECTED] | (2 rows) if I do this select: select * from (select test_id, email_a FROM test WHERE email_a = '[EMAIL PROTECTED]') as s, (select test_id, email_b from test where email_b = '[EMAIL PROTECTED]') as t; I get no rows back. should it return something? subquery a doesn't return one, because the email does not exist, b returns something. how do I have to make the query so I get a result back and in one row? -- [ Clemens Schwaighofer -----=====:::::~ ] [ TEQUILA\ Japan IT Group ] [ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ] [ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ] [ http://www.tequila.co.jp ]
signature.asc
Description: OpenPGP digital signature