Database

How should the query behave if you have a row with B2 but none with B1? Should the row with B2 be included or not? Wrong is evil and must be defeated. - Jeff Ello[^]

So, you don't want to understand your own problem and learn how to solve it and then you expect someone else to write code for you?

You've already asked a similar question in the same forum, please do not litter the forum with duplicate questions. If you wish to add information to your question, edit your original question and add the information there. Posting duplicate questions will not get you any helpful answers unless you explain your problem well. If English is not your primary language, you can explain your problem with examples.

DisIsHoody wrote: @jschell: In response to item 2, how can I check this? Myself I use telnet (client). If you do not have this installed already then it already in the OS (windows) just go the "control panel" -> "Programs and Features" -> "Turn Windows features on or off" and then look for "Telnet Client". You run telnet with the following command in a console window. telnet All you care about is whether it connects or not. If it connects you get a blank screen. If it fails, which can take some time (or not) you get an error. You can find the regular ip of your computer by running the following command (windows) in a console window. ipconfig Both of the databases you cited use port 3306 by default. So using the above the following three commands should tell you what is going on. telnet local host 3306 telnet 127.0.0.1 host 3306 telnet host 3306 If all three fail then it means you are using a different port. If just the localhost one fails then it means you have redirected local host. If just the first two fail then it means that you have set your database up to bind to your regular ip and not 127.0.0.1. The above of course makes the assumption that your really are running the database on your local box (and that your test with the GUI tool was valid and was actually connecting to the database on your box and not some database on another box.)

I suggest you to go with SQL Server Compact Edition[^] or Sqlite[^]. These're lightweight & easy for beginners. Use this site for connectionstrings to all databases. www.connectionstrings.com[^] Strongly recommend ADO.NET[^]. Buy a DB related book from this list. Useful Reference Books[^] For tutorials & related things, check it out below one. Education Needed[^] thatraja Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

Hi, Maybe that table was dropped or renamed?

Arun Sylvester J wrote: is a Live(production) and the other is local database. Probably depends on exactly what that means. Certainly in normal production systems there is no access at all to the database outside of the hosting center. And of course if you really have a "local" database on some random client machine then just allowing arbitrary duplication is normally going to be a security concern.

After asking so many questions, i finally succeeded in tweaking out a query that is correct. it is as follows; Select Customer, Count, Credit, Debit, Balance, Date from ( Select Customer_ID as Customer, (count(Credit) + count(Debit)) as Count, sum(Credit) as Credit, sum(Debit) as Debit from ThriftsTrans Where Transaction_Date Between '15/Dec/2013' And '18/Dec/2013' Group By Customer_ID ) as a left join ( Select Customer_ID as Cust, Account_Balance as Balance, Transaction_Date as Date From ThriftsTrans Where Transaction_Date In (Select Max(Transaction_Date) From ThriftsTrans Where Transaction_Date Between '15/Dec/2013' And '18/Dec/2013' Group By Customer_ID) ) as b on a.Customer = b.Cust thanks to you all

Are you able to show the code where the exception occurs? I think its something to do with the number of connections that you create. Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

Share your query first thatraja Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

OK Good Suggestion, I tried and got success, Thanks

Looking at the W3 school, it shows table to table joins, not database to database joins. Here is what I have so far... (minus the insert, and it works) SELECT * from Table1 join Database2.Table2 on ColumnX = ColumnY X is a Column in Database1.Table1, and Y is a Column in Database2.Table2. This gets me my info when I run the query on Database1. But now I want write these info into Database2.Table3 and delete what was in there before. So would my statement then be...?? DELETE * FROM Database2.Table3 INSERT INTO Database2.Table3 SELECT * from Table1 join Database2.Table2 on ColumnX = ColumnY

Had to download Reflector to check this. Also had to update my understanding about SqlDataReader. Tonight I'll eventually deepfry an author of an article, if I can find it back. :sigh: Wrong is evil and must be defeated. - Jeff Ello[^]

Sorry I could not be of more help.

ok . thanks for your reply.

Before it's validated, it will be validating[^]. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

rakeshjena wrote: Examples are welcomed than links It's not something that can be explained with a copy/paste example. If you want a full-text search, then you have to configure[^] the server. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]