Query 2 tables..?

Results 1 to 2 of 2

Thread: Query 2 tables..?

  1. #1
    Join Date
    Dec 1969

    Default Query 2 tables..?

    I have data in 2 tables but only want to get the info from one based on the data in the other. Would I use a join?<BR><BR>table1 has 2 fields:<BR>RecordID and ApprovalNumber<BR><BR><BR><BR>table2 has 5 fields<BR>RecordID, name, address, street, etc<BR><BR>I want to query all table2&#039;s records ONLY where the RecordID in both tables match.<BR><BR>Any help on this would be appreciated.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Please post questions like the in the DB forum

    select name, address, street, etc from Table2 T2, Table1 T1 where T2.RecordID = T1.RecordID<BR><BR>i think

Posting Permissions

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