Re: I don't understand...

Hi All again,
after I deleted the "null row" from carname:
SELECT DISTINCT h_name
FROM haszon
WHERE h_name NOT IN (SELECT cn_name FROM carname)

+---------------+
| h_name        |
+---------------+
| DAEWOO-FSO    |
| DAEWOO-LUBLIN |
| GAZ           |
| TATA          |
+---------------+
Query OK, 4 rows in set (0,13 sec)

It's working now, but is it correct?

Bye, Gabor.

> I think it's good, but
> SELECT DISTINCT h_name
> FROM haszon
> WHERE h_name NOT IN (SELECT cn_name FROM carname)
>
> +--------+
> | h_name |
> +--------+
> +--------+
> Query OK, 0 rows in set (0,10 sec)
>
> Why ?
>
> postgres-7.1 rpm on RedHat 7.0
>
> Thanks, Gabor