I set up few tables in MySQL as follow:-
Table A
CID
Name
PID
ConID
Table B
CID
Contact
Name
.....
Table C
PID
Desc
....
I need to create a new table using Table A (PID, CID) to join Table B and Table C.
I am using MySQL 5.0.27 and FDO 3.4, Map3D works perfectly, but I cannot do it in Studio 2010. Does anyone has any ideas?