I want to get everything from user than if record exist in admin so user has admin(administrator) in table user with user.id = admin.admin_id, so I need to get 'admin' first_name and last_name
If there is no record in table admin with adin.user_id = user.id , than I need at least all records from user Table: user | id | int(10) | | PRI | NULL | auto_increment | | email | varchar(100) | YES | | NULL | | | password | varchar(45) | YES | | NULL | | | first_name | varchar(100) | YES | | NULL | | | last_name | varchar(100) | YES | | NULL | | | type | enum('admin','user') | YES | | NULL | auto_increment | Table: admin | id | int(10) | | PRI | NULL | auto_increment | | admin_id | int(10) | YES | | NULL | | | user_id | int(10) | YES | | NULL | | | date | datetime | YES | | NULL | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]