2 Query Builder bugs

[BJCooperIT]

I had an existing query something like:

SELECT *
FROM SUPERVISOR_TAB
WHERE SUPERVISOR_CODE in(
2, --Bill
7, --Frank
10, --Marcia
15) --Sarah

I then used query builder to add a table and specific fields to the query and the result was:

SELECT *,
INDIVIDUAL_TAB.NAME,
INDIVIDUAL_TAB.JURY_ELIGIBLE_YN,
INDIVIDUAL_TAB.ORGAN_DONOR_YN
FROM SUPERVISOR_TAB,
INDIVIDUAL_TAB
WHERE SUPERVISOR_CODE in(
2,
7,
10,
15)
AND SUPERVISOR_TAB.SEQ = INDIVIDUAL_TAB.SEQ

The "SELECT *," will not run without an alias and the comments are missing.

 

[Marco Kalter]

We'll fix it.

 

[BJCooperIT]

Thanks Marco, keep up the good work!