Importing from mainframe woes

S

SirPoonga

I am importing data from a mainframe extracted file (text) into several
tables based on the record layout information for each line of that
file.

I need to generate a report using two of the tables. The tables have
two keys, ID_ITEM and ID_OPER. The tables are "operation" and "notes".

What I want is a left join. I want all the records form "operation"
and only the matching records form "notes". Some of the
ID_ITEM/ID_OPER combinations won't have notes so they won't be in the
"notes" table. How do you left join with more than one field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing mainframe woes 6
Adding data to MS Access from csv file 0
Nested query problem 6
Hex 0D 0A 1A at end of imported file 1
Append Query gives errors 0
FOCUS Mainframe 0
New Record in subform with 2 table problem 1
Search/Extract Specific Data from all fields in a table 1

Top