This is my 2 tables.
account_details (account_number, nic, full_name, phone_number, address, gender, date_of_birth,__)
account (account_number, name_with_initials,account_type, fd_period,__)
I want to select records in both the tables. This is my SQL line.
$query ="SELECT account_details. nic,full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period". "FROM account_details,account". "WHERE account_details.account_number=account.account_number";
The following error occurs.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.account_number=account.account_number' at line 1