SQL Query...

Results 1 to 2 of 2

Thread: SQL Query...

  1. #1
    Join Date
    Dec 1969

    Default SQL Query...

    Can you use an innerjoin in an insert statement? <BR><BR>I have two tables, they both share the field ACCNO, I want to copy the field ADDRESS from table1 to table2 where ACCNO matches. I cannot figure out the SQL for this!<BR><BR>Can anyone help???<BR><BR>T.I.A :@]

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Query...

    It&#039;s not possible in a single statement - in SQL server, there&#039;s a way round it though - see &#039;save yourself SQL hassles at http://www.infinitemonkeys.ws/infinitemonkeys/all-asp.asp<BR><BR>should help. providing you&#039;re using SQL Server

Posting Permissions

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