Stix83 (2/11/2016)
View 2 works great however view one is the issue.here is my joining statement:
sELECT B.CONTACT AS CONTACT,
B.MAIN AS PHONE,
B.CELL AS CELL,
B.DATE_OF_CONTACT AS DATE,
B.NOTE AS REFERENCE,
B.ADVERSE_EVENT AS AE,
B.IDENTIFIED_BY_MED_INFO AS IBMF,
A.NUMERICCOL AS ACTION_TAKEN,
B.type as Type
FROM CSV A
INNER JOIN CSV1 B ON A.client_id = b.client_id
GROUP BY A.NUMERICCOL, B.ADVERSE_EVENT, B.IDENTIFIED_BY_MED_INFO, B.CONTACT, B.NOTE, B.DATE_OF_CONTACT, B.MAIN, B.CELL, b.type
What happens is the following, only the entries that have a value in the numericcol are returned however I don't want that, I want all entries regardless if they have a value or not to be returned.
Please help!!
Hello, I did not study the query very intensly, but maybe a 'OUTER JOIN' does help,
change the 'INNER JOIN' into 'RIGHT OUTER JOIN' to get all rows from CSV1.
Tip!
Use the Query Designer in studio manager.
Set the select in focus. (The complete select statement should be selected as if you want to run the statement).
Press Ctrl/Shift/Q, this brings you into the Query designer.
A join should be visible, right clicking on the diamond shape gives you the option to select all rows from either (or both) of the tables.
Please tell us if this did help.
Ben