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...
You're missing a "PUB" on comBreadInvoiceDetail :
INNER JOIN "PUB"."comBreadInvoiceDetail"
Or you can use defaultSchema="PUB" on your JDBC connection.
You're missing a "PUB" on comBreadInvoiceDetail :
INNER JOIN "PUB"."comBreadInvoiceDetail"
Or you can use defaultSchema="PUB" on your JDBC connection.
Man!!!! :| You know how often I reviewed that stuff and didn't see it? Thank you!!!