Home » SQL & PL/SQL » SQL & PL/SQL » regarding sql query
regarding sql query [message #618115] Tue, 08 July 2014 04:30 Go to next message
IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae
Junior Member

details of items in our store

Table1

slno. item qty
1 dina 5
2 dina1 4
3 dina2 6
4 dina3 4
5 dina4 8


we are moving items from store to showroom

Table2

slno. item qty moveddate
1 dina 2 30-06-2014
2 dina1 3 30-06-2014

Table 2 tells that two items are moved on specific date to our showroom

table3

slno. item qty returndate
1 dina 2 05-07-2014
2 dina1 2 05-07-2014

This table tells when items cane back to store

one item sold dina1 on 03-07-2014

Dear All,
My requirement is how to write query to know how may days an item was on showroom based on return date in table 3 if sold any item sold date.


Thanks in Advance,
Regards,
Irfan.M.

please reply to irfanmbaig@gmail.com
Re: regarding sql query [message #618116 is a reply to message #618115] Tue, 08 July 2014 04:34 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
No, this not your requirement. Your requirement is to say "thank you" to people who have assisted you before on all your previous questions, and to read our OraFAQ Forum Guide and read How to use [code] tags and make your code easier to read

You have been asked to do all this before.


Re: regarding sql query [message #618121 is a reply to message #618115] Tue, 08 July 2014 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From your previous topics:

Michel Cadot wrote on Sun, 11 August 2013 09:39
...
Please read OraFAQ Forum Guide.
...


pablolee wrote on Tue, 08 October 2013 10:26
Hi Irfan. You've posted a few questions now. And in each of those questions, people have given up their time for free to offer you advice. Up until now, you have posted no acknowledgment of their efforts. It is considered a general forum courtesy to post such an acknowledgement (to, for example, say whether the information you received was useful/successful or not)

Cheers


Updated on: Sat, 31 May 2014 15:29 by Moderator
*BlackSwan added {code} tags. Please do so yourself in the future.
please read http://www.orafaq.com/forum/t/174502/102589/


Lalit Kumar B wrote on Sun, 01 June 2014 09:35
Please provide the create and insert statements.


Michel Cadot wrote on Sun, 15 June 2014 14:00

Maybe you should think to feedback and thank people that helped you in your previous topics before posting a new one.
And maybe you should read and follow OraFAQ Forum Guide and How to use [code] tags and make your code easier to read as already asked to you.





Re: regarding sql query [message #618123 is a reply to message #618116] Tue, 08 July 2014 05:26 Go to previous messageGo to next message
IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae
Junior Member

Dear all,

Little late but First of all I want to thank for your efforts and time.Next time when i post query i will follow the code rules.Sorry for inconvenience happened.

Regards,
Irfan.M.
Re: regarding sql query [message #618124 is a reply to message #618115] Tue, 08 July 2014 05:37 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
So do it. Firstly you should determine what shall be the result (required columns and values in rows) and what are rules which are leading to it.

Then, I would start with SELECT keyword. As you did not post any SQL for reproducing your environment (CREATE TABLE + INSERT statements, see http://www.orafaq.com/wiki/Test_case), I will not post ant SQL too.

P.S. I am sure that spammers will love you for publishing your email on public forum.
Re: regarding sql query [message #618126 is a reply to message #618123] Tue, 08 July 2014 05:59 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, start now posting a test case (in the proper format).

Previous Topic: how to recover data from clob
Next Topic: column name and procedure parameter are same in oracle
Goto Forum:
  


Current Time: Fri Apr 26 13:57:22 CDT 2024