* id call_status callstatus_despt

* id call_type calltype_despt

* id name active

* AvlLeaveId Id Year Month LeaveType LeaveDate

* city_id city_name

* id company_name service_charge_value vat_charge_value address phone country message currency

* company_id company_name address1_street address1_locality address1_city address1_state address1_pincode contact1_phone contact1_fax website contact2_phone

* ContactId CustomerId Name PhoneNumber Designation EmailId Notes Active_Record Lastupddt Lastupdby CreatedDate CreatedBy

* ContactId CustomerId Name PhoneNumber Designation EmailId Notes Active_Record Lastupddt Lastupdby CreatedDate CreatedBy

* CustomerId OrgName CreatedDate Adress_Street Address_locality Address_City Pincode Landline_Number Org_Phonenumber Faxnumber Website Active_Record Notes_Abt_Customer CreatedBy Lastupdby Lastupddt

* DeptCode department_name

* id DeptCode EmployeeName firstname lastname phone EmployeeId Password EmployeeActive Reporting Lastupddt Lastupdby EmployeeEmail

* employmenttype_id employmenttype_name

* id group_name permission

* holiday_id holiday_date description

* jobtitle_id jobtitle_name

* id DeptCode EmployeeId LeaveType StartDate EndDate StartTime EndTime DayTime LeaveReason CreatedBy CreatedDate

* locality_id locality_name city_id

* id Call_Date EmployeeId CustomerId ContactId EncounterBy EncounterType productcategory_id product_id Status Follow_Up_Date Notes

* id bill_no date_time gross_amount service_charge_rate service_charge_amount vat_charge_rate vat_charge_amount discount net_amount user_id table_id paid_status store_id

* id order_id product_id qty rate amount

* payment_mode_id payment_mode

* payroll_calendar_id year month month_id pay_date

* payroll_details_id payroll_calendar_id EmployeeId Basic DA HRA Special SignonBonus TA PT TDS PTOUsed PTORemaining LeaveWithoutPay

* id category_name

* id category_id store_id name price description image active

* productcategory_id product_id product_name

* id productcategory_id product_id

* EmployeeId Year CTC PTOAllowed

* Id Address Address2 City State Pincode

* Id employmenttype_id jobtitle_id DeptCode StartDate EndDate

* resource_status_id resource_status

* SettingName SettingValue

* id name active

* BidNumber Title BidStatus Description SolicitationType ContractType DepartmentName Category SetAsideType FundingSource ContractVehicle NAICSCode NAICSCodeDesc QandA QandADueDate BidResponseDueDate BidPostedDate

* BEGoalID BidNumber BidBEGoalPercent BEGoalType

* BidNumber FieldChange FromValue ToValue CreatedUserId

* BidDocID BidNumber DocTypeDesc DocName DocPathName

* id item_name parent_id

* id username password email firstname lastname phone gender old_password new_password

* id user_id group_id

* Id jobtitle_id DeptCode EmpName jobtitle_name department_name StartDate

* Id EmpName PTOUsed PTORemaining payroll_calendar_id Basic DA HRA Special SignonBonus TA PT TDS payroll_details_id

*

select table callstatus_list calltype_list category checkavailableleave city_list company company_info contactperson contactperson1 customerlist department employeelist employmenttype groups holiday_list jobtitle leavedatebase locality_list marketingcalllog orders order_items payment_mode payroll_calendar payroll_details productcategory products producttype product_interest pto_details resourceaddress resourceemployment resource_status setting stores tbid tbidbegoal tbidchangelog tbiddoc tbl_categories users user_group vemployeedetails vemployeepayrolldetails vemplpayrollcalcdetailsfinal . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table callstatus_list calltype_list category checkavailableleave city_list company company_info contactperson contactperson1 customerlist department employeelist employmenttype groups holiday_list jobtitle leavedatebase locality_list marketingcalllog orders order_items payment_mode payroll_calendar payroll_details productcategory products producttype product_interest pto_details resourceaddress resourceemployment resource_status setting stores tbid tbidbegoal tbidchangelog tbiddoc tbl_categories users user_group vemployeedetails vemployeepayrolldetails vemplpayrollcalcdetailsfinal .	select column