Kcarson

Out of curiosity, are you not joining on a particular field? As of right now, you are doing a join with a number of rows equal to (rows in Property) x (Rows in Sales_Staff) x (rows in Vendor), which unless all three tables are very small means your view is going to return a lot of rows. Just noticed and thought I would mention it.

Using XHTML 1.0, found I keep getting errors for links with special characters, example: http://w3schools.invisionzone.com/index.ph...ost&CODE=00&f=4That would work, it has = and & ampersand,which is correct to replace the = with? And ampersand with & in URLs.Yet I still keep getting validator errors, any ideas?

<{POST_SNAPBACK}>

suggestion:  why did they not standardize the SQL statement use by any database vendor ?

<{POST_SNAPBACK}>

"The computer industry (like most industries) both benefits and suffers from standards. We said that SQL is an open standard, not owned by a company, and the standard comes from ANSI. Therefore the SQL standard from ANSI is considered the "pure" SQL and called ANSI-SQL.Two problems emerge to sully this pureness. First is that every DBMS vendor wants to differentiate their DBMS products. So if you look at the feature set of each DBMS product you see that not only does the product support ANSI-SQL but it also offers extra features, enhancements or extensions that are available only from individual vendors. For example, most vendors offer a field type which auto- increments even though this is not described in the SQL standards. These additions to ANSI-SQL are generally proprietary and will not work if you try to use them on competitor's SQL products. Many of these features are powerful and robust, but since they vary from vendor to vendor, programmers should use them with caution. It is always safest to stick with pure SQL whenever possible; if you stray it should be with full knowledge that you are losing the portability of your statements (and perhaps even your data).Such enhancements are not all bad because these extensions are very useful. For example, ANSI-SQL does not contain an automatic way to assign a serial number to each new record but most DBMS sold today have added this feature. Since serial numbering is so common programmers are happy to have the enhancement. However, the method of implementation is not uniform, so code written to get the serial number from data in one DBMS may not work when used with another vendor's DBMS."

Thanks mate it works fine with the first query. thanks

<{POST_SNAPBACK}>

Sorry Friend i can't find .but  i need oracle 9i  free document

<{POST_SNAPBACK}>

PLEASE....TOP 4 is for SQL Server, LIMIT 4 is for MySql...you cannot use both!

<{POST_SNAPBACK}>

SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server. It is not an extention of SQL.Also LIMIT is for MySql, you need to use WHERE ROWNUM <= number in oracle.Anothere different is the CHARINDEX() function used in SQL Server, Oracel used INSTR() instead.

<{POST_SNAPBACK}>

Okay, you have to be careful when using the rownum function. It numbers the rows before you do the order by, which is why you are missing the three rows. To fix this, all you need to do is place your original query (minus the rownum references) in a subquery, and in the outer query check for rownum. Query should look like this:

select *from ( select sum(d.price), e.Title, d.dvd_idfrom dvd_rental d, dvd_details ewhere months_between(sysdate, order_date) < 13 and e.dvd_id = d.dvd_idgroup by d.dvd_id, e.titleorder by sum(d.price) desc)where rownum <= 10

I have also heard that there is another way to do this, and that is

SELECT FIRST 10 sum(d.price), e.Title, d.dvd_idFROM dvd_rental d, dvd_details eWHERE months_between(sysdate, order_date) < 13 AND e.dvd_id = d.dvd_idGROUP BY d.dvd_id, e.titleORDER BY sum(d.price) DESC

Hopefully one of those two will work for you

Hi,Everyone. I have a request that is , do u know any  website name  that provide free  complete oracle document.bye

<{POST_SNAPBACK}>

I already researched and all the  websites said I needed some kind of script to run the auctions.  I think it was a java scripts.  But, all I wanted to do is just get my site up and auctions going.  But, I'm not sure what kind of codes to use to get the auctions listed.

<{POST_SNAPBACK}>

Isn't Java embedded though? I think Java is considered client-side... Isn't that why we need a plugin to view them? If it were server-side we wouldn't need a java plugin =P.

<{POST_SNAPBACK}>

1. how long do i have to study to be a web designer?That all depends on how fast of a learner you are and how much time you devote to it.2. do i have to take a university course or sth lyk tt? if yes...how long?See Skemcin's answer.3. do i need some basic requirements to be a web-designer?if yes.. wat is it?There is a quote that says, you know you are "Fill-in-the-blank" when a "Fill-in-the-blank" calls you one. In this case, you will be a web designer when a web designer calls you one. 4. will i do well by working as a web-designer?I don't think any of us know you well enough to tell you that, but if you want to be one, then you should. It is as simple as that.5. what other jobs is it available other than being a web-designer?See Skemcin's Answer again.Now for my own personal un-asked for suggestion:I would also suggest doing websites on the side for friends/family. That way you can gain some experience, decide which path you want to take (design/develop/etc.) and it will also allow you to show more examples of your work when you try to obtain a job in this field.Best of luck as you venture into this area.

Hi there,I came accross the "www.w3schools.com" website and saw that there are quite a few certification exams one could complete; can you tell me if this certification is approved by W3C and if it is Internationally recognized ? (At least in South Africa, Australia and New Zealand)Thank youPieter Jacobs

<{POST_SNAPBACK}>

i was looking into xml... now is that only good for lists, or would i be able to grab a part of the xml and place it into the html... im also going to looking into php ( id like to learn it either way ) oh yeah and one more question, any idea on what the best way to sell things would be, as of right now im leaning toward paypal

<{POST_SNAPBACK}>

I won't tell the folks at Opera about this:http://video.google.com/videoplay?docid=3908309829962763267    

<{POST_SNAPBACK}>

Tnx m8. But since i am a n00b (and cant find anything  ) So... how do i get colored text?

<{POST_SNAPBACK}>

Okay, Scott I figured out how to get it all into one query....kind of ugly and not very efficient probably but it works....Here it is:

SELECT War.WarID, War.Map, War.Mode, War.Time, War.ClanPlayed, Sum(VCLScores.Flags),    (SELECT Sum(OtherScores.Flags) FROM War War1     JOIN OtherScores ON OtherScores.WarID = War1.WarID    WHERE OtherScores.WarID = War.WarID)FROM War JOIN VCLScores ON VCLScores.WarID = War.WarIDGROUP BY War.WarID

Explanation: rather than have an additional column Sum(OtherScores.Flags), I added a column containing the query with War and OtherScores joined with just one result sum(OtherScores.Flags). I then tell it to only produce the results when the OtherScores WarID matches the War.WarID contained outside the current statement (the one joined with VCLScores).....Like I said, its not pretty and I would like to know if anybody could do it better and I really mean that .Well, let me know if you have any problems with it, or if you need a better explanation of things, or any other questions, I would be glad to help

Your query solved the problem, thank you.

<{POST_SNAPBACK}>

And Plz tell me difference bet. ORACLE SQL*PLUS  AND MS SQL

<{POST_SNAPBACK}>

Here is a good article showing the differences between MS SQL 2000 and Oracle 9i. Obviously both databases have been updated since the article was written but it should give you a rough idea. It was actually harder to find a good article then I thought, since most of them were completely biased, as in the whole site/magazine would be dedicated to one or the other and then try to say they were giving objective opions on the two....anyways, I digress, the link below should take you to a good unbiased review comparing the two (older versions though).http://www.databasejournal.com/features/ms...10894_2170201_2Let me know if you have any questions.

Hi,    I can't understand what is the difference bet.  SQL SERVER 2000  SQL andORACLE SQL.

<{POST_SNAPBACK}>

Do I sound like a query expert yet? lol!  Thanks again for the assist.Joel

<{POST_SNAPBACK}>

By the way Joel, what happened to the other 7 possible repsonses?....that is one of the pieces that kept making me think it was going to be very hard....the fact that there were 11 possible responses.Well, I was just curious.

That was easier that we thought!  I figured out how to do the multiple joins and it works like a charm!  Thanks very much for your help in looking at this Kcarson. Your suggestions were key in creating this solution.  Can I buy you a beer?Best Regards,Joel

<{POST_SNAPBACK}>

So you basically want to query an excel spreadsheet . . . a.) excel is not a database - and therefore should not be used as oneb.) if you are thinking about using excel as a database, then you need to think about using a databasec.) you should build something to upload/parse/insert the spreadsheet into a database and query it from there (much more flexibility)

<{POST_SNAPBACK}>