Not working to perform joins

[vasharma1]

The english statement 'What is the name of the professor who is teaching the field Algorithm ?' does not work. There comes an error saying 'there is at least one column 'field' which is not reachable from 'professor'.

[FerreroJeremy]

Thank you for your interest in ln2sql. Unfortunately, I'm not going forward with the project.

In addition, FYI, the pypi version is really not updated; it does not include most of features of the github version, the same goes for the release versions and especially for the python 2.X version. Maybe your problem comes from here.

I'm so sorry not to be able to help you more.

[jps1001]

@vasharma1 That is because the sql dump file does not contain the relation between primary key and foreign key. You have to define your ALTER TABLE statements. And then add :
ALTER TABLE professor
ADD CONSTRAINT professor_ibfk_1 FOREIGN KEY (idProf) REFERENCES teaching (idProf);

Thanks.

[aitoehigie]

Sad to see this project has been abandoned