當我create 完呢兩個table之後,
又入左第一組data落egcard之後,入第二組果陣就出左個error
應該點算?
而另一個database就入呢三個table
想做以下查詢
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埋一齊