How to fetch old data with new database? suppose current inventory store in current database but after new year starting i want to store new year data in new database so howto fetch old data

Questions by nitincpatel

Showing Answers 1 - 2 of 2 Answers

Culver_lake

  • Mar 21st, 2006
 

since the data is in two different tables you have two different choices, JOIN or UNION.  In this case you would probably use UNION. However you can make it much simpler by just leaving the data in the same table. The primary key and date columns will let you retrieve just what you want.  Unless the table is really large and needs this kind of archiving do yourself a favor and just leave it where it is.

  Was this answer useful?  Yes

Laxmi Prasad

  • Apr 2nd, 2007
 

u can call that data using database name.tablename.fields

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions