Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?
Ex:
select employees.emp_no,
employees.ename,
departments.dept_no
from
(select dept_no from dept) departments,
(select emp_no, ename from emp) employees
where employees.dept_no = departments.dept_no
In the above example, first the compiler forms 2 inline views employees and departments and then joins these 2 in the where clause.
But can we form the "employees" inline view to have only those rows based on the results of "departments" query.
Thanks
Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and give the total amount of sales?
array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in...." error on the following site: http://nwsurfing.com/buoy.phpi
Calander Basic Spript help
hi, just starting out with PHP and have the following script: <?php //This gets today's date $date =time () ; //This puts the day, month, and year in seperate variables $day = date('d', $date)
Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thought I could use the ASCII function, but SELECT ASCII('é') FROM DUAL in Oracle gives me 50089.
FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?<embed src='player-viral.swf' width='263' height='220' bgcolor='undefined'
rookie looking for help coding a CSS form with PHP
I'm trying to figure out how to add PHP code to my xhtml form so that it is a working form embedded in the contact us page of a website that is still on my pc only. The end goal is to place the PHP
xApp Analytics in BI 7.0
Dear all,
Add 5 to a variable when a button is clicked, and re-run a for loop
So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to do everything I want except for this. I want the script to only show 5 at a time (which i have
Search with relational database
Hey,I have quite a complicated (for me anyway ) relational database for an apartments system I am developing.Keith (kickstart) was very helpful assisting me in creating the relationships and here is
Allowing ' and "
Hello everyone,I am creating a form where users submit information to go into a database. I want the users to be allowed to use both ' and " in their messages, but the problem is when I try to
