Hi, Thurstan
On Thu, 20 Sep 2001 17:30:46 +0100, "Thurstan R. McDougle"
<[EMAIL PROTECTED]> wrote:
> [...]
>Carl van Tast had 2 good methods as follows
>
>SELECT userid, val
>FROM tbl
>WHERE NOT EXISTS (SELECT * FROM tbl AS t2
> WHERE tb
this before? ;-)) You might try:
SELECT tab.* FROM tab, tab2 WHERE tab.col1 = tab2.col2;
or SELECT DISTINCT ... , if col2 is not unique in tab2.
Kind regards,
Carl van Tast
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
e_id = matches.people_id
AND matches.match_count = searched.attribute_count;
and it seems to work now.
>Thank you very much,
>Frederick
HTH,
Carl van Tast
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
ml
WHERE state IN (2, 5)
GROUP BY jid) ml2
ON (j.id = ml2.jid)
WHERE j.fkey = 1;
HTH,
Carl van Tast
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ml1
ON (j.id = ml1.jid)
LEFT JOIN (SELECT jid, COUNT(*) cnt
FROM ml
WHERE state IN (2, 5)
GROUP BY jid) ml2
ON (j.id = ml2.jid)
WHERE j.fkey = 1;
HTH,
Carl van Tast
On Tue, 11 Sep 2001 02:26:32 + (UTC), [EMAIL PROTECTED] (Joseph
Shraibman) wrote:
&g
x27;c')
set identity_insert foo off
insert into foo (txt) values ('b')
select * from foo
id txt
--- --
1 a
2 b
10 c
11 d
(4 row(s) affected)
.02 by
Carl van Tast
---(end of broadcast)--
