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