Question: Please write the SQL language for the query that created for the (frm= form) above in this database system for employee table.. 101 Employee Employee

 Please write the SQL language for the query that created forthe (frm= form) above in this database system for employee table.. 101Employee Employee ID - First Name - Zalina + E102 Fred +E103 Amin + E104 Sally + E105 Wei Hao Last Name -

Please write the SQL language for the query that created for the (frm= form) above in this database system for employee table..

101 Employee Employee ID - First Name - Zalina + E102 Fred + E103 Amin + E104 Sally + E105 Wei Hao Last Name - Ahmad Brown Ali Lee Tan Gender Female Male Male Female Male Address 15, Tmn Harmoni, Bangi 4, Kajang Hill, Kajang 51, Megan Avenue, TTDI 41, TTDI Jaya, Shah Alam 1 2732 Ckt Permata Taman Permata Hulu Postcode State - Phone Number - 43050 Selangor 012-4562340 43500 Selangor 019-2176588 50000 Wilayah Persekutuan Kuala Lumpur 016-8976533 50510 Selangor 013-4578124 53300 Selangor 019-3354949 0 ** QEmployee Employee 1 emplD fName IName gender address postcode state phoneNumber vfName Employee IName Employee gender Employee address Employee postcode Employee state Employee phone Number Employee Field: emplD Table: Employee Sort: Show: Criteria: or: QEmployee SELECT Employee.emplD, Employee.fName, Employee.IName Employee.gender, Employee address, Employee.postcode, Employee.state, Employee.phoneNumber FROM Employee QEmployee Employee frmEmployee Syatikat Perkhidmatan Tayar Kim Hiap Seng. Employee Information Employee ID E101 First Name Zalina Last Name Ahmad Gender Female Address 15, Tmn Harmoni, Bangi Postcode 43050 State Selangor Phone Number 012-4562340 101 Employee Employee ID - First Name - Zalina + E102 Fred + E103 Amin + E104 Sally + E105 Wei Hao Last Name - Ahmad Brown Ali Lee Tan Gender Female Male Male Female Male Address 15, Tmn Harmoni, Bangi 4, Kajang Hill, Kajang 51, Megan Avenue, TTDI 41, TTDI Jaya, Shah Alam 1 2732 Ckt Permata Taman Permata Hulu Postcode State - Phone Number - 43050 Selangor 012-4562340 43500 Selangor 019-2176588 50000 Wilayah Persekutuan Kuala Lumpur 016-8976533 50510 Selangor 013-4578124 53300 Selangor 019-3354949 0 ** QEmployee Employee 1 emplD fName IName gender address postcode state phoneNumber vfName Employee IName Employee gender Employee address Employee postcode Employee state Employee phone Number Employee Field: emplD Table: Employee Sort: Show: Criteria: or: QEmployee SELECT Employee.emplD, Employee.fName, Employee.IName Employee.gender, Employee address, Employee.postcode, Employee.state, Employee.phoneNumber FROM Employee QEmployee Employee frmEmployee Syatikat Perkhidmatan Tayar Kim Hiap Seng. Employee Information Employee ID E101 First Name Zalina Last Name Ahmad Gender Female Address 15, Tmn Harmoni, Bangi Postcode 43050 State Selangor Phone Number 012-4562340

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!