Help please

Results 1 to 3 of 3

Thread: Help please

  1. #1
    Join Date
    Dec 1969

    Default Help please

    Hi,<BR>Is it possible to open two tables at a time. I Have a table1 which contains the userid and email and the table 2 which contains all the details of the user. If a user login with email is it possible to retrieve the information from table2<BR><BR>Thanks<BR>

  2. #2
    MG Guest

    Default RE: Help please

    Yes it is possible. Instead of opening two tables though, you should open the results of an SQL statement. You can use SQL to join the two tables on the userid assuming the userid is in both tables. The when you use ASP to open the SQL statement, it will seem as if you only opening one table.

  3. #3
    Join Date
    Dec 1969

    Default RE: Help please

    yes, you will need to do a join on the two tables, it would look something like this:<BR><BR>SELECT field1.table1, field2.table2 WHERE field1.table1 = field2.Table2

Posting Permissions

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