• WorkplaceCodeWRegNumWorkplaceNameNumOfEmployeesEmpNameOfficePhNumAddressAddress_1Email

    105 099-1A Oracle 888 Wang ho 201543115 Hyundai-4-ga Hyundai-4-ga x@hdfc.com

    Above is the output when i run below query

    select distinct Workplace.[WorkplaceCode], Workplace.WRegNum ,Workplace.[WorkplaceName], Workplace.[NumOfEmployees],Employee.[EmpName],address.[OfficePhNum],address.[HomePhone], address.[Fax],address.[Address],address.[Address],address.homepage,address.[Email],Workplace.[Notes1],Workplace.[Notes2],Workplace.[Notes3] from Workplace

    left join Employee on Workplace.[EmpNumber] = employee.EmpNum

    left join Address on Workplace.[AddressId]=address.[Address_id]

    Also can you tell me if it is possible to disable Autoincrement field, i am using SQLite DB