Re: Converting MS Access SQL Query With INNER JOIN To Oracle SQL
Date: Fri, 10 Sep 2010 11:12:25 -0700 (PDT)
Message-ID: <2a65903e-4dae-40bd-b006-2ec26004c5f9_at_p22g2000pre.googlegroups.com>
On Sep 10, 9:54 am, "takv..._at_gmail.com" <takv..._at_gmail.com> wrote:
> On Sep 10, 12:28 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > On Sep 10, 8:17 am, "takv..._at_gmail.com" <takv..._at_gmail.com> wrote:
>
> > >http://www.progneer.com/wp/information_more_public.aspx?search_fd0=13...
> > > "Moreover, in MS Access using dates is very simple and straight-forward, all you have to do is to surround the date by # (hash symbol) but in Oracle SQL to use the date in the WHERE clause you have to use the TO_DATE function."
>
> > WTF??? No, I don't.
>
> > select count(*) from sales_order_headers where order_date > '01-
> > jan-2010';
>
> > COUNT(*)
> > ----------
> > 3740
>
> > update employee_separation set termination_date = (select sysdate from
> > dual) where idiot_name='TAKVEEN';
>
> > jg
> > --
> > _at_home.com is bogus.http://www.signonsandiego.com/news/2010/sep/08/making-sense-housing-n...
>
> The link you referenced in your reply is wrong and deprecated. Here
> is
> correct one:
>
> http://www.progneer.com/wp/information_more_public.aspx?search_fd0=13...
Ah, this spammer actually reads responses. Too bad he isn't bright enough to understand them.
Please stop your idiot spamming! Please stop your idiot misinformation! Though I really wouldn't care about the latter as long as nothing directs me to it and I don't have to bother with the resulting questions from confused people asking in online fora.
I think the link I posted was just google groups misquoting what you posted. Normally I would munge the thing myself, but I didn't happen to think of it. The correct link is still what I was referring to, and is still misinformation. Something is bothering me about the Having clause, but I don't have time to investigate it, I just assume Access is strange.
Funny thing is, I wouldn't have anything against someone posting a link to something that would help someone get from another product to Oracle (even though most here would consider that spam if unsolicited), but a separate post for each little snippet just smacks of SEO manipulation, a hallmark of commercial spamming.
jg
-- _at_home.com is bogus. And so, duty calls: http://xkcd.com/386/Received on Fri Sep 10 2010 - 13:12:25 CDT