Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Who can help me with a report in SQL
I have 2 tables and I want to have a report which shows the value in another currency. Table A (exchange rates) Date Rate Currency 1-1 1.11 USD 2-1 1.12 USD 3-1 1.13 USD...- harfri
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
Insert data from Table A into Table B how can I do that?
I have table A with my account balance and i would like to use this data to insert them into my new table B. In this table I would like to see my account balance per day. Is this possible with Oracle sql? Is there a insert statement or a function which i can use? I would be very happy if...- harfri
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Insert into a new table
Who can help me out? I have a table with a balance in USD with 2 records Table 1 Date. Balance 1-Jan-2018 100 USD 5-Jan-2018 200 USD I would like to know how i can create a new table based on Table 1 The new table should have the following records Date. Balance 1-Jan-2018... -
Select From...SecID
Can anyone help me with this SQL Query? I have two tabels TABEL A SECID SECSYMBOL US00111 AAA US00222 BBB US00333 CCC US00333 DDD US00333 EEE US00333 FFF TABEL B SECSYMBOL SECNUM AAA 1234 BBB 1235 CCC 1236 DDD 1237 EEE... -
Select From....Security ID
Can anyone help me with this SQL Query? I have two tabels TABEL A SECID SECSYMBOL US00111 AAA US00222 BBB US00333 CCC US00333 DDD US00333 EEE US00333 FFF TABEL B SECSYMBOL SECNUM AAA 1234 BBB 1235 CCC 1236 DDD 1237 EEE...- harfri
- Thread
- Replies: 16
- Forum: Microsoft: Access Queries and JET SQL
