[Typo3-dev] Newbie:Getting value from another table

[Georg Ringer]

Hello Franz,
many thanks for your answers and efforts but unfortunately I am a quite
newbie with writing extensions, with php and mysql.
It would be very great if you could give me a working example how to get a
value from another table.

My structure:
TABLE tx_rgzitate_zitat (
    zitat text NOT NULL,
    autorz int(11) unsigned DEFAULT '0' NOT NULL, => Database relation to
tx_rgzitate_autor.autor
)
TABLE tx_rgzitate_autor (
    uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
    autor tinytext NOT NULL,
)

Many thanks again
georg