Result Set for Database Query:

SELECT a1.TAB_ID, PFL, FAM, AUTOR, PUBJAHR, SERTITEL, SERBAND, PUBSEITE FROM Tabelle a1 Join Tab_Gehalt a2 on a1.Tab_ID = a2.Tab_ID Join Tab_Molekuel a3 on a2.Mol_ID = a3.Mol_ID WHERE a3.Mol_ID = 'M_343' ORDER by a3.MOL_ID ASC, a2.GEHALT2 ASC


No.TAB IDPlantFamilyAuthorsYearJournal
1.TAB_008735Larix olgensisPINACEAEWolff, R. L.
Aitzetmueller, K.
1999 unpublished results
2.TAB_008646Picea shrenkiana var. tianshanicaPINACEAEAitzetmueller, K.
Wolff, R. L.
1999 unpublished results
3.TAB_008737Picea marianaPINACEAEAitzetmueller, K.
Wolff, R. L.
1999 unpublished results




3 Records found.