search

defog-ai / sqlcoder

SoTA LLM for converting natural language questions to SQL queries
Apache License 2.0
3.41k stars 218 forks source link

how to give join statement in prompt when same column in multiple tables #84

Closed miteshgarg closed 7 months ago

miteshgarg commented 8 months ago

Hi Defog Team,

Need your suggestion on how to give a join statement in prompt when there is a same column in multiple tables.

Example: Table1 : circle_name, etc... Table2 : circle_name, etc... Table3 : circle_name, etc... Table4 : circle_name, etc...

I have tried with this in prompt but every time it un-necessarily joins with table1 to get the circle_name: -- Table1.circle_name can be joined with Table2.circle_name, Table3.circle_name, Table4.circle_name

Is there a better way to do this?

github-actions[bot] commented 7 months ago

This issue is stale because it has been open for 30 days with no activity.

github-actions[bot] commented 7 months ago

This issue was closed because it has been inactive for 14 days since being marked as stale.