Does anyone know if a one can query a 4D database selecting all of a particular table like one can do in MySQL? I haven't been able to find any documentation on it.
Fails
I've tried this query but it fails to parse Syntax error: 1301 Failed to parse statement.
SELECT c.Customer_Name, p.*
FROM Customer c
JOIN EOE_EDI_Partner p ON p.BillTo_Customer_ID = c.Customer_ID
Works
This works, but gets data from both tables
SELECT *
FROM Customer c
JOIN EOE_EDI_Partner p ON p.BillTo_Customer_ID = c.Customer_ID
And I'd like to refrain from writing out each field in the desired table (its a lot)
SELECT p.Name, p.ID, p.FieldName, p.......
FROM Customer c
JOIN EOE_EDI_Partner p ON p.BillTo_Customer_ID = c.Customer_ID