public static LedgerJournalTable findByGeneralJournalEntry( GeneralJournalEntry journalEntry ) { LedgerJournalTable journalTable; LedgerEntryJournal journalLink; ; select firstOnly * from journalLink where journalLink.RecId == journalEntry.LedgerEntryJournal join journalTable where journalTable.JournalNum == journalLink.JournalNumber;// && //journalTable.dataAreaId == journalLink.LedgerJournalTableDataAreaId; return journalTable; }