S
smat-consulting
Guest
Not sure what forum to post this question... OE 11.3, Windows 32, DataDirect JDBC driver I have two tables in my DB comBreadInvoice and comBreadInvocieDetail. If I do a simple select on wither one of them, data is displayed. If I do a join of the two, I get "Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)" the following two work: SELECT "comBreadInvoice"."totalCases"FROM "PUB"."comBreadInvoice" SELECT "comBreadInvoiceDetail"."lastUpdateOn" FROM "PUB"."comBreadInvoiceDetail" The following causes error: SELECT "comBreadInvoice"."totalCases", "comBreadInvoiceDetail"."lastUpdateOn" FROM "PUB"."comBreadInvoice" INNER JOIN "comBreadInvoiceDetail" ON ( "comBreadInvoiceDetail"."breadInvoice#" = "comBreadInvoice"."breadInvoice#" ) Anybody any ideas? Thanks...
Continue reading...
Continue reading...