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_037' ORDER by a3.MOL_ID ASC, a2.GEHALT2 ASC


No.TAB IDPlantFamilyAuthorsYearJournal
1.TAB_004991Grevillea decoraProteaceaeAhmad, F. et al.1987Lipids, Volume 22, Page(s) 413
2.TAB_002472Geranium pseudosibirieum J. MayeoGeraniaceaeunpublished results MRI1997
3.TAB_000007Ajuga genevensisLabiataeunpublished results MRI1996
4.TAB_002523Panzerina canescensLabiataeunpublished results MRI1995Bundesforschungsanstalt Muenster
5.TAB_002481Hepatica nobilisRannunculaceaeunpublished results MRI1997FSME Manhart, Wien
6.TAB_002475Glischrocaryon aureumHalorogaceaunpublished results MRI1988J. Amer. Oil Chem. Soc., Volume 59, Page(s) 23
7.TAB_002485Hepatica transsylvanicaRannunculaceaeunpublished results MRI1997FSME Manhart, Wien
8.TAB_002578Aster tripoliumCompositaeunpublished results MRI1998
9.TAB_002519Nymphaea albaNymphaeaceaeunpublished results MRI1998Bundesforschungsanstalt Muenster
10.TAB_002518Nuphar luteaNymphaeaceaeunpublished results MRI1998Bundesforschungsanstalt Muenster




10 Records found.