[GRASSLIST:1001] Populating fields of one table based on SQL query from another ta ble

[Patton, Eric]

I'm trying to build an SQL query where the DGPS northings and eastings from
a table of ship navigation gets written to a second table of sample
locations only where the two tables have matching timestamps. So I basically
have timestamps for my samples, but no positions. I'm unsure of the correct
sql syntax (using Sqlite):

Here's what the query should do:

"select * from Easting and Northing in Ship_Navigation WHERE Timestamp ==
Timestamp in Station_Samples." | db.execute

Is this type of query possible?

~ Eric.