Beakerboy / Beakerboy/VBA-SQL-Library

SQLSelect -->iSQLQuery_ToString - Problem with Join on 2 or more Tables

Open
#32 18 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
VBA
Stars
90
Forks
18
PR merge metrics
No merged PRs in 30d

Description

Issue detected when attempting to create SQLString if 2 or more tables are necessary to JOIN.
the resulting SQL contains error and cannot be used.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating SQLSelect and iSQLQuery_ToString in the repository, then reproduce the issue with a query that joins two or more tables. Inspect the generated SQL and compare it with the valid join syntax required by the reported case; done means the resulting SQL can be used successfully for multi-table joins.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.