mysql

Select Query

customer table
Customer IdCustomerNameDeptId
005MeenaD002
006ReenaD001
008DinaD002

salary table
IdSalaryDeptId
00520000D002
00620004D001
00830000D002

Department table
DepartmentDeptId
AccountD002
TechnicalD001
AccountD002
Q) select customer name from table with deptid

Select CustomerName, DeptId from customer

Q) select customer name from table where dept D002

Select CustomerName from customer where DeptId=’D002′

Leave a Reply

Your email address will not be published.

18 − nine =