Selecting Row Number in SQL Where Clause

[KenHudson]

I'm not versed in SQL and am trying to append a field of data from one table to another. The only criteria I want is to use the data in the first record of the "donor" table.
How can I phrase the Where clause correctly?

INSERT INTO Table1 ( LastDate )
SELECT Table2.NewDate
FROM Table2
WHERE (([Table2].RecordNumber)=1);

 

[james_lankford]

there really is no such thing as a record number

you can put an "order by" clause in your sql and it will bring records back in that order

so you could write these

select LastName, JoinDate, Zipcode from person 
order by Lastname 

select LastName, JoinDate, Zipcode from person 
order by JoinDate 

select LastName, JoinDate, Zipcode from person 
order by ZipCode

and each of them would have a different row show up as RecornNumber 1

your best bet is to use an order by clause or figure out if there is a "minimum" value in a column you can use

like

select PersonID, Amt_Purchased 
from some_table 
where 
Amt_Purchased  = 
(
  select min(Amt_Purchased)
  from some_table 
)

 

[KenHudson]

Thanks for the response James.
The problem is that every record has the same date in it.
So the query wants to append every record and I only want to append the date once.
What code other than "min" will select only one record's date?

INSERT INTO tbl_Processing_Date ( ProcessingDate )
SELECT Run_Date
FROM F829
WHERE
Run_Date=(select min(Run_Date) from F829);

 

[KenHudson]

This code seems to work:

INSERT INTO tbl_Processing_Date ( ProcessingDate )
SELECT F829.Run_Date
FROM F829
GROUP BY F829.Run_Date;