Member Avatar for yaginuk
yaginuk 0 Newbie Poster

HI,
I a have inhrited administration of a work database. we currently have the ability to export data to a xls file from a customers table, but i want to add employers information from the employers table i.e employers name, address etc along with each record exported.
This section deals with accessing main database/table:

.....
tablename = "[TbleMaster]"
strsql = "select * from [TblMaster]"
SQL = SQL & " StrRecNo LIKE '%%'"

......

how do i add from table TblEmployer
also, each customer in TblMaster has a Employer code from TblMaster - StrEmployer_Code which i will need to query/align with same code from TblEmployer database field - Employer_Code

cheers

dave

  • 1 Contributor
  • 0 Replies
  • 90 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.