Forum Discussion
Error when trying to connect to ODBC to MS Access databse
Well, if it was me here what I would do :
Create a view for Driver with everything you need
Create a view for Inspector with everything you need
Import your 3 tables in PowerBI and then you can join them and do everything you want, the software is kinda powerful
Solution SageTry that maybe ?
Select cl_details.ASSR_FEE, cl_details.CAU_DT, cl_details.Incident_Date, cl_details.Inv_amount, cl_details.Rep_Cost, tb_pers.Co_Name as DriverFirstName, tb_pers.Surname as DriverSurname from cl_details Left Join tb_pers as T2 on cl_details.pers_no = T2.ref_id left join tb_pers as T3 on cl_details.insp_id = T3.ref_id
Nope doesnt seem to like the alises, maybe have to do a select statement within the select
- quentin_vigne
Well, if it was me here what I would do :
Create a view for Driver with everything you need
Create a view for Inspector with everything you need
Import your 3 tables in PowerBI and then you can join them and do everything you want, the software is kinda powerful
Yeah dont think there is going to be an easy way....
Seems to be the syntax - Managed to get it working with.
Select
T1.ASSR_FEE,
T1.CAU_DT,
T1.Incident_Date,
T1.Inv_amount,
T1.Rep_Cost,
T2.CO_Name & ' ' & T2.Surname as DriverName,
T3.CO_Name & ' ' & T3.Surname as InspectorName
FROM
((cl_details T1)
LEFT OUTER JOIN tb_pers T2 on T1.pers_no = T2.ref_id)
LEFT OUTER JOIN tb_pers T3 on T1.insp_id = T3.ref_id