Joining tables - question

Results 1 to 2 of 2

Thread: Joining tables - question

  1. #1
    Join Date
    Dec 1969

    Default Joining tables - question

    Hello,<BR> I have a query which has to join two tables. I have field (field1) with same name in both the tables. The problem is the field1 in table one has to be joined with field1 and field2 of the second table. I mean the part of join statement is like this<BR><BR> join on (table1.filed1=table2.filed1&field2) <BR> <BR> when I used this query I got Ambiguous column error. Please help me it is Urgent.<BR><BR>Thank you<BR><BR>SIncerely<BR>Roopesh

  2. #2
    Joey Guest

    Default RE: Joining tables - question

    You need to name your columns correctly in your query then it will work. Do it like this.<BR><BR>Select table1.FirstName, table2.LastName From<BR><BR>and then your join 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