[htoolkit-users] Getting Relations? Perhaps lack of SQL knowledge

[Marc W. <mar...@gm...>]

Hi. I'm new to HSQL.
Is it possible to retrieve relation information?
If you have one table

CDID| CD Name
and another subtable
CDID| Track ID | Track Name | Track length | interpret

Is it possible to retrieve this 1:n relation information via (H)SQL ?
I think there was the references statement in CREATE Table query to
describe this (with sub item deletion and so on)

I want to write an applicatian which synchronizes databases.. So I
should know where to start. I think using MySQL you should be able to
find this information in the mysql database but I don't know enough
about ODBC and PostgreSQL. Access (from MS Win) also has got some kind
of describing tables. Would it be a good idea to think about integrating
getting this kind of information into HSQL?

Do you think HSQL is most advanced (I don't know about other libraries
accessing databases directly yet).

Marc