Re: [SQL] Need help building this query

2012-06-21 Thread Oliver d'Azevedo Christina
operations shouldn't have already been completed and, thus, without any record on table A ...? Could you please kindly elucidate me? Thank you Best, Oliver - Original Message - From: "Oliver d'Azevedo Christina" To: "Rihad" ; Sent: Thursday, June 21, 2012 7

Re: [SQL] Need help building this query

2012-06-21 Thread Oliver d'Azevedo Christina
For matching triples (foo, bar, baz) the date in table B shouldnt always be after any date in table A, as table B contains complete operations? Best, Oliver - Original Message - From: "Rihad" To: Sent: Thursday, June 21, 2012 6:48 PM Subject: [SQL] Need help building this query

Re: [SQL] Sorting data based fields in two linked tables

2011-05-14 Thread Oliver d'Azevedo Christina
Can you provide An example? Best, Oliveiros Enviado via iPhone Em 13/05/2011, às 04:00 PM, "R. Smith" escreveu: > Hi, > > I am looking for a way to sort data returned from two tables with the > first sort based on a field from table A and the secord sort based on > the results of the first so

Re: [SQL] identifying duplicates in table with redundancies

2010-09-24 Thread Oliver d'Azevedo Christina
Hey,Tarlika. I tried to reproduce your test case through a series of inserts and It seems that the lower case "d" went unnoticed. That explains the empty list i got as result. My fault. Sorry :-( Great to hear it helped you Best, Oliveiros Enviado de meu iPhone Em 24/09/2010, às 05:12 PM