Hello, has anyone know what is the best way to search address of customer I CAN search like this but seem the result return for me is not enough, anyone know the other query to search?

@Hung The address details are stored in the EntityAddress table. You can join like this:

SELECT
	*
FROM
	CustomerAddressbook
	INNER JOIN EntityAddress ON
		( EntityAddress.nkey = CustomerAddressbook.AddressBookAddress )

thanks

You're welcome! Good luck.