Abstract: A method and system for multi-table question answering is provided herein. The method includes receiving a complex question from a user. The method may further include decomposing the complex question into one or more sub-questions using one or more of but not limited to coreference resolution, dependency parsing, chunking and prompt techniques. The method may further include generating code scripts for each sub-question using a Large Language Model (LLM). The method may further include executing the code scripts to retrieve relevant structured data from a plurality of tables. The method may further include generating an answer to the complex question based on the retrieved structured data.