How to structure code

Results 1 to 2 of 2

Thread: How to structure code

  1. #1
    Join Date
    Dec 1969

    Default How to structure code

    I have 2 tables containing information that needs to produce a third table. Table 1 has a list of business types, each with an associated ID number. Table 2 just contains a long list of numbers, each of which can be matched up with the IDs in the Table 1 (so they are foreign keys). I need to compare this long list of numbers in Table 2 with the table containing the business types and IDs, to end up with a list of business types in Table 3.<BR><BR>I have no idea where to start with this. How should I structure my code?<BR><BR>TIA<BR>Kaz

  2. #2
    Join Date
    Dec 1969

    Default RE: How to structure code

    Read up on the SELECT INTO statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts