Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem with getting result with my query!!!
Finally I solved this query, thank you brother I really appreciate your help .. thank you again and again -
problem with getting result with my query!!!
I adjusted your query then I tried it and it showed me just one column not all the flights this is what I tried SELECT YEAR(plannedDeparture), MONTH(plannedDeparture), a.mid, m.`name`, COUNT(f.fid) AS `Total... -
problem with getting result with my query!!!
Hi bro here is my full schema SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; DROP SCHEMA IF EXISTS `SADB` ; CREATE SCHEMA IF NOT EXISTS... -
problem with getting result with my query!!!
This is my schema: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; DROP SCHEMA IF EXISTS `SADB` ; CREATE SCHEMA IF NOT EXISTS `SADB`... -
problem with getting result with my query!!!
Hi jpadie I tried your solution, but it doesn't work -
problem with getting result with my query!!!
Hi I have 3 tables which are (flight, model, airplane) Flight: fid, pid, aid, plannedDeparture, actualDeparture, passengerCount, destination Model: mid, name Airplane: aid, mid, oid, hid, dateAqu and I want to get a report to show the total number of flights and the average passenger count for...
