查看完整版本: 想問一0的SQL Statement點寫，唔該幫0下手

想問一0的SQL Statement點寫，唔該幫0下手

當我create 完呢兩個table之後，
[img]http://hk.geocities.com/jfksaihang/idb2.jpg[/img]又入左第一組data落egcard之後，入第二組果陣就出左個error
[img]http://hk.geocities.com/jfksaihang/idb.jpg[/img]
應該點算？
而另一個database就入呢三個table
[img]http://hk.geocities.com/jfksaihang/idb3.jpg[/img]
想做以下查詢
list晒所有customer names 同埋由2003-01-01至到2003-12-310既所有order日期
select concat(upper(left(cfname,1)),substring(cfname,2,length(cfname)),"
",upper(clname)) as Customer_Name from customerfour, * from orderfour where doo between 2003-01-01 and 2003-12-31;
呢句有error，唔知點解
list晒所有customer names 同埋將employee numbers(empno) associated with employee phone number(ephone)，仲要個bal 多個2000
select concat(upper(left(cfname,1)),substring(cfname,2,length(cfname)),"
",upper(clname)) as Customer_Name from customerfour, custno as Employee_Number, ephone as Employee_Phone_Number from customerfour left join employeefour on customerfour.custno = employeefour.ephone where bal > 2000;
又係error，唔知錯咩
同埋亦有2句唔係咁識寫
list晒唔同area之中邊個bal最大同最細個數目
list晒有邊個employee無order跟
customer names 同employee names要list成咁，for example landi wong變成Landi WONG，即係cfname或者efname要同clname或者elname combine埋一齊

QQQQQQQQQQQQQQQQQQ