searching linked tables

Results 1 to 2 of 2

Thread: searching linked tables

  1. #1
    Allen Weiss Guest

    Default searching linked tables

    I have a simple sql statement to select from an access table called Password:<BR>Query = "Select * from Password"<BR><BR>What I&#039d like to do is to go through this table and then go through another table (say, Password2) with the same query statement. I could execute another query statement, but instead could I link these tables together in Access, and if so, what should the query statement then look like?<BR>Thanks.

  2. #2
    Kru Guest

    Default RE: searching linked tables

    I was just checking up on this and it seems that the statement should be -:<BR>SELECT * FROM Table1,Table2<BR><BR>There were a coupla variations of linking two tables but this should b ok ...<BR><BR><BR>Kru

Posting Permissions

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